1 echo create table t1
(f1 int
, f2 int
);
3 echo create index hashidxt1f1 on t1
(f1
) hash;
5 echo create index hashidxt1f2 on t1
(f2
) hash;
7 echo create table t2
(f1 int
, f2 int
);
9 echo create index hashidxt2f1 on t2
(f1
) hash;
11 echo create index hashidxt2f2 on t2
(f2
) hash;
13 echo explain plan
select * from t1
,t2
;
15 <TYPE
> INNER_JOIN
</TYPE
>
19 <ScanType
> TableScan
</ScanType
>
25 <ScanType
> TableScan
</ScanType
>
29 echo explain plan
select * from t1
,t2 where t1.f1
=t2.f1
;
31 <TYPE
> INNER_JOIN
</TYPE
>
33 <FieldName1
> t1.f1
</FieldName1
>
34 <FieldName2
> t2.f1
</FieldName2
>
35 <CompOp
> Equals
</CompOp
>
40 <ScanType
> TableScan
</ScanType
>
46 <ScanType
> TableScan
</ScanType
>
50 echo explain plan
select * from t1
,t2 where t1.f1
<=t2.f1
;
52 <TYPE
> INNER_JOIN
</TYPE
>
54 <FieldName1
> t1.f1
</FieldName1
>
55 <FieldName2
> t2.f1
</FieldName2
>
56 <CompOp
> LessThanEquals
</CompOp
>
61 <ScanType
> TableScan
</ScanType
>
67 <ScanType
> TableScan
</ScanType
>
71 echo explain plan
select * from t1
,t2 where t1.f1
!=t2.f1
;
73 <TYPE
> INNER_JOIN
</TYPE
>
75 <FieldName1
> t1.f1
</FieldName1
>
76 <FieldName2
> t2.f1
</FieldName2
>
77 <CompOp
> NotEquals
</CompOp
>
82 <ScanType
> TableScan
</ScanType
>
88 <ScanType
> TableScan
</ScanType
>