exp.test007.ksh

b树实现源码,linux和unix下运行,速度快,极好用

CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT );
CREATE INDEX indx on t1 ( f1 )  UNIQUE;
SET AUTOCOMMIT OFF;
INSERT INTO t1 VALUES(0,5);
INSERT INTO t1 VALUES(1,5);
INSERT INTO t1 VALUES(2,5);
INSERT INTO t1 VALUES(3,5);
INSERT INTO t1 VALUES(4,5);
INSERT INTO t1 VALUES(5,5);
INSERT INTO t1 VALUES(6,5);
INSERT INTO t1 VALUES(7,5);
INSERT INTO t1 VALUES(8,5);
INSERT INTO t1 VALUES(9,5);
INSERT INTO t1 VALUES(999991,5);
INSERT INTO t1 VALUES(999992,5);
INSERT INTO t1 VALUES(999993,5);
INSERT INTO t1 VALUES(999994,5);
INSERT INTO t1 VALUES(999995,5);
INSERT INTO t1 VALUES(999996,5);
INSERT INTO t1 VALUES(999997,5);
INSERT INTO t1 VALUES(999998,5);
INSERT INTO t1 VALUES(999999,5);
COMMIT;