test/sql/Optimizer/exp.test025.ksh

   1 echo create table t1(f1 int, f2 int);
   2 Statement Executed
   3 echo create index treeidxt1f1 on t1(f1) tree;
   4 Statement Executed
   5 echo create index treeidxt1f2 on t1(f2) tree;
   6 Statement Executed
   7 echo explain plan select a.f1,b.f1 from t1 a, t1 b where a.f1=b.f1;
   8  <JOIN-NODE>
   9  <TYPE> INNER_JOIN </TYPE>
  10  <PREDICATE>
  11  <FieldName1> a.f1 </FieldName1>
  12  <FieldName2> b.f1 </FieldName2>
  13  <CompOp> Equals </CompOp>
  14  </PREDICATE>
  15  <LEFT>
  16    <TABLE-NODE>
  17    <NAME> t1 </NAME>
  18    <ScanType> TableScan </ScanType>
  19    </TABLE-NODE>
  20  </LEFT>
  21  <RIGHT>
  22    <TABLE-NODE>
  23    <NAME> t1 </NAME>
  24    <ScanType> TableScan </ScanType>
  25    </TABLE-NODE>
  26  </RIGHT>
  27  </JOIN-NODE>
  28 Statement Executed