1 CREATE TABLE t1
(f1 SMALLINT NOT NULL
, f2 INT
);
2 CREATE INDEX t1_PRIMARY on t1
( f1
) HASH UNIQUE SIZE
10007 ;
3 INSERT INTO t1 VALUES
(1,1111);
4 INSERT INTO t1 VALUES
(2,2222);
5 CREATE TABLE t1
(f1 SMALLINT NOT NULL
, f2 INT
);
6 CREATE INDEX t1_PRIMARY on t1
( f1
) HASH UNIQUE SIZE
10007 ;
7 INSERT INTO t1 VALUES
(1,1111);
8 INSERT INTO t1 VALUES
(2,2222);
9 INSERT INTO t1 VALUES
(5,5555);
10 INSERT INTO t1 VALUES
(6,6666);