1 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT
);
2 CREATE INDEX t1_PRIMARY on t1
( f1
) HASH UNIQUE
;
3 CREATE INDEX t1_idx2 on t1
( f2
) HASH
;
5 INSERT INTO t1 VALUES
(1,11);
6 INSERT INTO t1 VALUES
(2,21);
7 INSERT INTO t1 VALUES
(3,31);
8 INSERT INTO t1 VALUES
(4,41);
9 INSERT INTO t1 VALUES
(5,51);
10 INSERT INTO t1 VALUES
(6,61);
11 INSERT INTO t1 VALUES
(7,71);
12 INSERT INTO t1 VALUES
(8,81);
13 INSERT INTO t1 VALUES
(9,91);
14 INSERT INTO t1 VALUES
(10,101);
