Here is the full explain output from v1202_0830 build. >>prepare ss from +>update TRAFODION."_MD_".OBJECTS set catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name = 'TAB_EMP_NEW_01' where object_uid = 158802970814398584; --- SQL command prepared. >>explain ss; ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... SS PLAN_ID .................. 212284413487002637 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ update TRAFODION."_MD_".OBJECTS set catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name = 'TAB_EMP_NEW_01' where object_uid = 158802970814398584; ------------------------------------------------------------------ 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 input_variables ........ %('TRAFODION'), %('ALTER_RENAME_RENAME21'), %('TAB_EMP_NEW_01'), %('TRAFODION'), %('ALTER_RENAME_RENAME21'), %('TAB_EMP_NEW_01'), %(158802970814398584) 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 %(158802970814398584)), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.CATALOG_NAME assign TRAFODION."_MD_".OBJECTS.CATALOG_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEMA_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_ NAME assign %('ALTER_RENAME_RENAME21')), (TRAFODION."_MD_".OBJECTS.OBJECT_NAME assign %('TAB_EMP_NEW_01')), (TRAFODION."_MD_".OBJECTS.OB JECT_TYPE assign TRAFODION."_MD_".OBJECTS.OBJECT_T YPE), (TRAFODION."_MD_".OBJECTS.OBJECT_UID assign %(158802970814398584)), (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 begin_key .............. (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = %(158802970814398584)) end_key ................ (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = %(158802970814398584)) 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 = %(158802970814398584)) --- SQL operation complete.