1 echo create table t1
(f1 int
, f2 int
);
3 echo create index treeidxt1f1 on t1
(f1
) tree
;
5 echo create index treeidxt1f2 on t1
(f2
) tree
;
7 echo explain plan
select a.f1
,b.f1 from t1 a
, t1 b where a.f1
=b.f1
;
9 <TYPE
> INNER_JOIN
</TYPE
>
11 <FieldName1
> a.f1
</FieldName1
>
12 <FieldName2
> b.f1
</FieldName2
>
13 <CompOp
> Equals
</CompOp
>
18 <ScanType
> TableScan
</ScanType
>
24 <ScanType
> TableScan
</ScanType
>