1 create table t1( f1 int, f2 int, f3 varchar(20), primary key (f1));
2 create index idx on t1(f2);
3 insert into t1 values (1,1,'First');
4 insert into t1 values (2,1,'Second');
5 insert into t1 values (3,1,'Third');
6 insert into t1 values (4,1,'Fourth');
7 insert into t1 values (5,1,'Fifth');
