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