1 echo create table t1 (f1 varchar(10), f2 smallint);
2 create table t1 (f1 varchar(10), f2 smallint);
3 echo create table t2 (f1 varchar(10), f2 smallint);
4 create table t2 (f1 varchar(10), f2 smallint);
5 echo create index idx1 on t1(f1) hash;
6 create index idx1 on t1(f1) hash;
7 echo create index idx2 on t2(f1) hash unique;
8 create index idx2 on t2(f1) hash unique;
9 insert into t2 values('Lakshya1',10);
10 echo insert into t2 values('Lakshya1',20);
11 insert into t2 values('Lakshya1',20);
12 echo select * from t1;
14 echo select * from t2;