Comment 2 for bug 1324303

Revision history for this message
Julie Thai (julie-y-thai) wrote :

Verified on workstation, daily build 20140807_0830.
Verified cardinality of hybrid_hash_join reflects left child of the join.
>>control query shape hybrid_hash_join(scan(TABLE 'T', path 'TRAFODION."_MD_".TABLE_CONSTRAINTS', forward
, blocks_per_access 1 , mdam off),
scan(TABLE 'O', path 'TRAFODION."_MD_".OBJECTS_UNIQ_IDX', forward
, blocks_per_access 1 , mdam off));
+>+>+>
--- SQL operation complete.
>>prepare st1 from select T.CONSTRAINT_TYPE, o.OBJECT_NAME from trafodion."_MD_".table_constraints T, trafodion."_MD_".objects O where T.table_uid = o.object_uid;

--- SQL command prepared.
>>explain options 'f' st1;

LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------

3 . 4 root 1.00E+002
2 1 3 hybrid_hash_join u 1.00E+002
. . 2 trafodion_scan TABLE_CONSTRAINTS 1.00E+002
. . 1 trafodion_index_scan OBJECTS 1.00E+002

--- SQL operation complete.