1 echo create index idx1 on t1(f1) hash;
2 create index idx1 on t1(f1) hash;
3 echo create index idx2 on t2(f1) hash;
4 create index idx2 on t2(f1) hash;
5 echo create index idx3 on t3(f1) hash;
6 create index idx3 on t3(f1) hash;
7 echo create index idx4 on t1(f2) tree;
8 create index idx4 on t1(f2) tree;
9 echo create index idx5 on t2(f2) tree;
10 create index idx5 on t2(f2) tree;
11 echo create index idx6 on t3(f2) tree;
12 create index idx6 on t3(f2) tree;