It looks like the plan is missing key expressions for the index delete. The plan is ok when the object_uid is parameterized. When the object_uid is given a value, both vsbb_delete and delete seems to have problem. Trafodion Conversational Interface 1.2.0 (c) Copyright 2014 Hewlett-Packard Development Company, LP. >>set parserflags 131072 ; --- SQL operation complete. >>prepare s1 from >>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = ? .. >>; .. --- SQL command prepared. >>explain options 'f' s1 ; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 8 . 9 root x 1.00E+000 6 7 8 nested_join 1.00E+000 . . 7 trafodion_insert OBJECTS_UNIQ_IDX 1.00E+000 4 5 6 nested_join 1.00E+000 . . 5 trafodion_insert OBJECTS 1.00E+000 3 . 4 sort 1.00E+000 1 2 3 nested_anti_semi_joi 1.00E+000 . . 2 trafodion_vsbb_delet OBJECTS_UNIQ_IDX 1.00E+000 . . 1 trafodion_delete OBJECTS 1.00E+000 --- SQL operation complete. >>explain s1; ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... S1 PLAN_ID .................. 212299007795473919 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = ? ; ------------------------------------------------------------------ NODE LISTING ROOT ====================================== SEQ_NO 9 ONLY CHILD 8 REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master statement_index ........ 0 affinity_value ......... 0 max_max_cardinality .... 1 total_overflow_size .... 0.00 KB upd_action_on_error .... xn_rollback xn_access_mode ......... read_only xn_autoabort_interval 0 auto_query_retry ....... enabled for privilege checks plan_version ....... 2,600 embedded_arkcmp ........ used self_referencing_update forced_sort IS_SQLCI ............... ON LDAP_USERNAME input_variables ........ ?, %('TRAFODION'), %('SCH'), %('OBJECT1'), %('TRAFODION'), %('SCH'), %('OBJECT1') NESTED_JOIN =============================== SEQ_NO 8 CHILDREN 6, 7 REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner join_method ............ nested TRAFODION_INSERT ========================== SEQ_NO 7 NO CHILDREN TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ _IDX new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@" assign ?), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.CATA LOG_NAME assign TRAFODION."_MD_".OBJECTS.CATALOG_N AME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEMA_NA ME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE) NESTED_JOIN =============================== SEQ_NO 6 CHILDREN 4, 5 REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner join_method ............ in-order nested TRAFODION_INSERT ========================== SEQ_NO 5 NO CHILDREN TABLE_NAME ............... TRAFODION._MD_.OBJECTS REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS (implements update of clustering key or unique index key) new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign %('TRAFODION')), (TRAFODION."_MD_".OBJECTS.SCHEMA_ NAME assign %('SCH')), (TRAFODION."_MD_".OBJECTS.O BJECT_NAME assign %('OBJECT1')), (TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE), (TRAFODION."_MD_".OBJECTS.OBJECT_UID assign ?), (TRAFODION."_MD_".OBJECTS.CREATE_TIME assign TRAFODION."_MD_".OBJECTS.CREATE_TIME), (TRAFODION."_MD_".OBJECTS.REDEF_TIME assign TRAFODION."_MD_".OBJECTS.REDEF_TIME), (TRAFODION."_MD_".OBJECTS.VALID_DEF assign TRAFODION."_MD_".OBJECTS.VALID_DEF), (TRAFODION."_MD_".OBJECTS.DROPPABLE assign TRAFODION."_MD_".OBJECTS.DROPPABLE), (TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign TRAFODION."_MD_".OBJECTS.OBJECT_OWNER), (TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER), (TRAFODION."_MD_".OBJECTS.FLAGS assign TRAFODION."_MD_".OBJECTS.FLAGS) SORT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION memory_quota ........... 0 MB max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master sort_type .............. full self_referencing_update forced_sort sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE NESTED_ANTI_SEMI_JOIN ===================== SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner anti-semi join_method ............ nested TRAFODION_VSBB_DELETE ===================== SEQ_NO 2 NO CHILDREN TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... index_trafodion_vsbb_delete TRAFODION."_MD_".OBJECTS_UNIQ_IDX begin_key .............. (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = ?) end_key ................ (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = ?) TRAFODION_DELETE ========================== SEQ_NO 1 NO CHILDREN TABLE_NAME ............... TRAFODION._MD_.OBJECTS REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est ........... 1 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS (implements update of clustering key or unique index key) columns ................ all begin_keys(incl) end_keys(incl) predicate .............. (cast((cast(TRAFODION."_MD_".OBJECTS.OBJECT_UID) * cast(1000000))) = cast(?)) --- SQL operation complete. >>fc pre >>prepare s1 from .. >>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = ? .. 12344 >>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = 12344 .. >>; .. --- SQL command prepared. >>cqd query_cache '0' ; --- SQL operation complete. >>fc pre >>prepare s1 from .. >>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = 12344 .. >>; .. --- SQL command prepared. >>explain options 'f' s1 ; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 8 . 9 root x 1.00E+001 6 7 8 nested_join 1.00E+001 . . 7 trafodion_insert OBJECTS_UNIQ_IDX 1.00E+000 4 5 6 nested_join 1.00E+001 . . 5 trafodion_insert OBJECTS 1.00E+000 3 . 4 sort 1.00E+001 1 2 3 nested_anti_semi_joi 1.00E+001 . . 2 trafodion_vsbb_delet OBJECTS_UNIQ_IDX 1.00E+000 . . 1 trafodion_delete OBJECTS 1.00E+001 --- SQL operation complete. >>fc expl >>explain options 'f' s1 ; .. ddddddddddd >>explain s1 ; .. ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... S1 PLAN_ID .................. 212299010512379427 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = 12344 ; ------------------------------------------------------------------ NODE LISTING ROOT ====================================== SEQ_NO 9 ONLY CHILD 8 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master statement_index ........ 0 affinity_value ......... 0 max_max_cardinality ... 10 total_overflow_size .... 0.00 KB upd_action_on_error .... xn_rollback xn_access_mode ......... read_only xn_autoabort_interval 0 auto_query_retry ....... enabled for privilege checks plan_version ....... 2,600 embedded_arkcmp ........ used self_referencing_update forced_sort IS_SQLCI ............... ON LDAP_USERNAME QUERY_CACHE ............ 0 NESTED_JOIN =============================== SEQ_NO 8 CHILDREN 6, 7 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner join_method ............ nested TRAFODION_INSERT ========================== SEQ_NO 7 NO CHILDREN TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ _IDX new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@" assign 12344), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX. CATALOG_NAME assign TRAFODION."_MD_".OBJECTS.CATAL OG_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEM A_NAME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME ), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE) NESTED_JOIN =============================== SEQ_NO 6 CHILDREN 4, 5 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner join_method ............ in-order nested TRAFODION_INSERT ========================== SEQ_NO 5 NO CHILDREN TABLE_NAME ............... TRAFODION._MD_.OBJECTS REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS (implements update of clustering key or unique index key) new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign 'TRAFODION'), (TRAFODION."_MD_".OBJECTS.SCHEMA_NAM E assign 'SCH'), (TRAFODION."_MD_".OBJECTS.OBJECT_ NAME assign 'OBJECT1'), (TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE), (TRAFODION."_MD_".OBJECTS.OBJECT_UID assign 12344), (TRAFODION."_MD_".OBJECTS.CREATE_TIME assign TRAFODION."_MD_".OBJECTS.CREATE_TIME), (TRAFODION."_MD_".OBJECTS.REDEF_TIME assign TRAFODION."_MD_".OBJECTS.REDEF_TIME), (TRAFODION."_MD_".OBJECTS.VALID_DEF assign TRAFODION."_MD_".OBJECTS.VALID_DEF), (TRAFODION."_MD_".OBJECTS.DROPPABLE assign TRAFODION."_MD_".OBJECTS.DROPPABLE), (TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign TRAFODION."_MD_".OBJECTS.OBJECT_OWNER), (TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER), (TRAFODION."_MD_".OBJECTS.FLAGS assign TRAFODION."_MD_".OBJECTS.FLAGS) SORT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION memory_quota ........... 0 MB max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master sort_type .............. full self_referencing_update forced_sort sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE NESTED_ANTI_SEMI_JOIN ===================== SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner anti-semi join_method ............ nested TRAFODION_VSBB_DELETE ===================== SEQ_NO 2 NO CHILDREN TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... index_trafodion_vsbb_delete TRAFODION."_MD_".OBJECTS_UNIQ_IDX columns ................ all unique_rows ....... 12,344 TRAFODION_DELETE ========================== SEQ_NO 1 NO CHILDREN TABLE_NAME ............... TRAFODION._MD_.OBJECTS REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS (implements update of clustering key or unique index key) columns ................ all begin_keys(incl) end_keys(incl) predicate .............. (TRAFODION."_MD_".OBJECTS.OBJECT_UID = cast(12344)) --- SQL operation complete. >>cqd hbase_rowset_vsbb_opt 'off' ; --- SQL operation complete. >>fc pre >>prepare s1 from .. >>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = 12344 .. >>; .. --- SQL command prepared. >> >>fc expl >>explain s1 ; .. ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... S1 PLAN_ID .................. 212299010813162386 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = 12344 ; ------------------------------------------------------------------ NODE LISTING ROOT ====================================== SEQ_NO 9 ONLY CHILD 8 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master statement_index ........ 0 affinity_value ......... 0 max_max_cardinality ... 10 total_overflow_size .... 0.00 KB upd_action_on_error .... xn_rollback xn_access_mode ......... read_only xn_autoabort_interval 0 auto_query_retry ....... enabled for privilege checks plan_version ....... 2,600 embedded_arkcmp ........ used self_referencing_update forced_sort IS_SQLCI ............... ON LDAP_USERNAME QUERY_CACHE ............ 0 HBASE_ROWSET_VSBB_OPT OFF NESTED_JOIN =============================== SEQ_NO 8 CHILDREN 6, 7 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner join_method ............ nested TRAFODION_INSERT ========================== SEQ_NO 7 NO CHILDREN TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ _IDX new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@" assign 12344), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX. CATALOG_NAME assign TRAFODION."_MD_".OBJECTS.CATAL OG_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEM A_NAME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME ), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE) NESTED_JOIN =============================== SEQ_NO 6 CHILDREN 4, 5 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner join_method ............ in-order nested TRAFODION_INSERT ========================== SEQ_NO 5 NO CHILDREN TABLE_NAME ............... TRAFODION._MD_.OBJECTS REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS (implements update of clustering key or unique index key) new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign 'TRAFODION'), (TRAFODION."_MD_".OBJECTS.SCHEMA_NAM E assign 'SCH'), (TRAFODION."_MD_".OBJECTS.OBJECT_ NAME assign 'OBJECT1'), (TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE), (TRAFODION."_MD_".OBJECTS.OBJECT_UID assign 12344), (TRAFODION."_MD_".OBJECTS.CREATE_TIME assign TRAFODION."_MD_".OBJECTS.CREATE_TIME), (TRAFODION."_MD_".OBJECTS.REDEF_TIME assign TRAFODION."_MD_".OBJECTS.REDEF_TIME), (TRAFODION."_MD_".OBJECTS.VALID_DEF assign TRAFODION."_MD_".OBJECTS.VALID_DEF), (TRAFODION."_MD_".OBJECTS.DROPPABLE assign TRAFODION."_MD_".OBJECTS.DROPPABLE), (TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign TRAFODION."_MD_".OBJECTS.OBJECT_OWNER), (TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER), (TRAFODION."_MD_".OBJECTS.FLAGS assign TRAFODION."_MD_".OBJECTS.FLAGS) SORT ====================================== SEQ_NO 4 ONLY CHILD 3 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION memory_quota ........... 0 MB max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master sort_type .............. full self_referencing_update forced_sort sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE NESTED_ANTI_SEMI_JOIN ===================== SEQ_NO 3 CHILDREN 1, 2 REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0.01 EST_TOTAL_COST ........... 0.01 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master join_type .............. inner anti-semi join_method ............ nested TRAFODION_DELETE ========================== SEQ_NO 2 NO CHILDREN TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX REQUESTS_IN .............. 1 ROWS_OUT ................. 1 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... index_trafodion_delete TRAFODION."_MD_".OBJECTS_UNIQ _IDX columns ................ all unique_rows ....... 12,344 TRAFODION_DELETE ========================== SEQ_NO 1 NO CHILDREN TABLE_NAME ............... TRAFODION._MD_.OBJECTS REQUESTS_IN .............. 1 ROWS_OUT ................ 10 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0 DESCRIPTION max_card_est .......... 10 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS (implements update of clustering key or unique index key) columns ................ all begin_keys(incl) end_keys(incl) predicate .............. (TRAFODION."_MD_".OBJECTS.OBJECT_UID = cast(12344)) --- SQL operation complete. >>log e