Here is the plan for the delete statement generated from v1202_0830
>>set parserflags 131072;
--- SQL operation complete. >>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 options 'f' ss;
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. >>
Could we get the plan from v1108_0830 build?
Here is the plan for the delete statement generated from v1202_0830
>>set parserflags 131072;
--- SQL operation complete. "_MD_". OBJECTS set catalog_name = 'TRAFODION', schema_name = 'ALTER_ RENAME_ RENAME21' , object_name = 'TAB_EMP_NEW_01' where object_uid = 158802970814398584;
>>prepare ss from
+>update TRAFODION.
--- SQL command prepared.
>>explain options 'f' ss;
LC RC OP OPERATOR OPT DESCRIPTION CARD ------- ------ -------- ------- ------- ------ ---------
---- ---- ---- -------
8 . 9 root x 1.00E+001 anti_semi_ joi 1.00E+001 vsbb_delet OBJECTS_UNIQ_IDX 1.00E+000
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_
. . 2 trafodion_
. . 1 trafodion_delete OBJECTS 1.00E+001
--- SQL operation complete.
>>
Could we get the plan from v1108_0830 build?