Comment 2 for bug 1395840

Revision history for this message
Justin Du (justin-du-2) wrote :

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?