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.
Verified on workstation, daily build 20140807_0830. hash_join( scan(TABLE 'T', path 'TRAFODION. "_MD_". TABLE_CONSTRAIN TS', forward "_MD_". OBJECTS_ UNIQ_IDX' , forward "_MD_". table_constrain ts T, trafodion. "_MD_". objects O where T.table_uid = o.object_uid;
Verified cardinality of hybrid_hash_join reflects left child of the join.
>>control query shape hybrid_
, blocks_per_access 1 , mdam off),
scan(TABLE 'O', path 'TRAFODION.
, blocks_per_access 1 , mdam off));
+>+>+>
--- SQL operation complete.
>>prepare st1 from select T.CONSTRAINT_TYPE, o.OBJECT_NAME from trafodion.
--- SQL command prepared.
>>explain options 'f' st1;
LC RC OP OPERATOR OPT DESCRIPTION CARD ------- ------ -------- ------- ------- ------ ---------
---- ---- ---- -------
3 . 4 root 1.00E+002 index_scan OBJECTS 1.00E+002
2 1 3 hybrid_hash_join u 1.00E+002
. . 2 trafodion_scan TABLE_CONSTRAINTS 1.00E+002
. . 1 trafodion_
--- SQL operation complete.