1 echo create table t1(f1 int,f2 int);
2 create table t1(f1 int,f2 int);
3 echo create index idx1 on t1(f2) tree;
4 create index idx1 on t1(f2) tree;
5 echo create index idx2 on t1(f1) tree;
6 create index idx2 on t1(f1) tree;
7 echo create table t2(f1 int,f2 int);
8 create table t2(f1 int,f2 int);
9 echo create index idx3 on t1(f2,f1) hash;
10 create index idx3 on t1(f2,f1) hash;