test/sql/Optimizer/exp.test001.ksh

   1 echo No Primary key -Test Case - 1,2,3
   2 echo select * from t1;
   3  <TABLE-NODE>
   4  <NAME> t1 </NAME>
   5  <ScanType> TableScan </ScanType>
   6  </TABLE-NODE>
   7 echo select * from t1 where f1=10;
   8  <TABLE-NODE>
   9  <NAME> t1 </NAME>
  10  <ScanType> TableScan </ScanType>
  11    <PREDICATE>
  12    <FieldName1> f1 </FieldName1>
  13    <CompOp> Equals </CompOp>
  14    <OperandPtr> VALUE </OperandPtr>
  15    </PREDICATE>
  16  </TABLE-NODE>
  17 echo select * from t1 where f1>10;
  18  <TABLE-NODE>
  19  <NAME> t1 </NAME>
  20  <ScanType> TableScan </ScanType>
  21    <PREDICATE>
  22    <FieldName1> f1 </FieldName1>
  23    <CompOp> GreaterThan </CompOp>
  24    <OperandPtr> VALUE </OperandPtr>
  25    </PREDICATE>
  26  </TABLE-NODE>
  27 Statement Executed
  28 echo Primary key -Test Case - 4,5,6
  29 echo select * from t1;
  30  <TABLE-NODE>
  31  <NAME> t1 </NAME>
  32  <ScanType> TableScan </ScanType>
  33  </TABLE-NODE>
  34 echo select * from t1 where f1=10;
  35  <TABLE-NODE>
  36  <NAME> t1 </NAME>
  37  <ScanType> HashScan </ScanType>
  38    <PREDICATE>
  39    <FieldName1> f1 </FieldName1>
  40    <CompOp> Equals </CompOp>
  41    <OperandPtr> VALUE </OperandPtr>
  42    </PREDICATE>
  43  </TABLE-NODE>
  44 echo select * from t1 where f1>10;
  45  <TABLE-NODE>
  46  <NAME> t1 </NAME>
  47  <ScanType> TableScan </ScanType>
  48    <PREDICATE>
  49    <FieldName1> f1 </FieldName1>
  50    <CompOp> GreaterThan </CompOp>
  51    <OperandPtr> VALUE </OperandPtr>
  52    </PREDICATE>
  53  </TABLE-NODE>
  54 Statement Executed
  55 echo Hash Index -Test Case - 7,8,9
  56 echo select * from t1;
  57  <TABLE-NODE>
  58  <NAME> t1 </NAME>
  59  <ScanType> TableScan </ScanType>
  60  </TABLE-NODE>
  61 echo select * from t1 where f2=10;
  62  <TABLE-NODE>
  63  <NAME> t1 </NAME>
  64  <ScanType> HashScan </ScanType>
  65    <PREDICATE>
  66    <FieldName1> f2 </FieldName1>
  67    <CompOp> Equals </CompOp>
  68    <OperandPtr> VALUE </OperandPtr>
  69    </PREDICATE>
  70  </TABLE-NODE>
  71 echo select * from t1 where f2>10;
  72  <TABLE-NODE>
  73  <NAME> t1 </NAME>
  74  <ScanType> TableScan </ScanType>
  75    <PREDICATE>
  76    <FieldName1> f2 </FieldName1>
  77    <CompOp> GreaterThan </CompOp>
  78    <OperandPtr> VALUE </OperandPtr>
  79    </PREDICATE>
  80  </TABLE-NODE>
  81 Statement Executed
  82 echo Tree Index -Test Case - 10,11,12
  83 echo select * from t1;
  84  <TABLE-NODE>
  85  <NAME> t1 </NAME>
  86  <ScanType> TableScan </ScanType>
  87  </TABLE-NODE>
  88 echo select * from t1 where f3=10;
  89  <TABLE-NODE>
  90  <NAME> t1 </NAME>
  91  <ScanType> TreeScan </ScanType>
  92    <PREDICATE>
  93    <FieldName1> f3 </FieldName1>
  94    <CompOp> Equals </CompOp>
  95    <OperandPtr> VALUE </OperandPtr>
  96    </PREDICATE>
  97  </TABLE-NODE>
  98 echo select * from t1 where f2>10;
  99  <TABLE-NODE>
 100  <NAME> t1 </NAME>
 101  <ScanType> TreeScan </ScanType>
 102    <PREDICATE>
 103    <FieldName1> f3 </FieldName1>
 104    <CompOp> GreaterThan </CompOp>
 105    <OperandPtr> VALUE </OperandPtr>
 106    </PREDICATE>
 107  </TABLE-NODE>