1 echo create table t1(f1 int, f2 int);
2 create table t1(f1 int, f2 int);
3 echo create index hashidxt1f1 on t1(f1) hash;
4 create index hashidxt1f1 on t1(f1) hash;
5 echo create index hashidxt1f2 on t1(f2) hash;
6 create index hashidxt1f2 on t1(f2) hash;
7 echo explain plan select a.f1,b.f1 from t1 a, t1 b where a.f1=b.f1;
8 explain plan select a.f1,b.f1 from t1 a, t1 b where a.f1=b.f1;