exp.test002.ksh

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

CREATE TABLE t1 (f1 INT  NOT NULL , f2 CHAR (30));
CREATE INDEX t1_idx1_Primary on t1 ( f1 )  UNIQUE;
SET AUTOCOMMIT OFF;
INSERT INTO t1 VALUES(51, 'Praba');
INSERT INTO t1 VALUES(2, 'Lakshya2');
INSERT INTO t1 VALUES(3, 'Lakshya3');
INSERT INTO t1 VALUES(4, 'Kishor');
INSERT INTO t1 VALUES(5, 'Lakshya5');
INSERT INTO t1 VALUES(6, 'Lakshya6');
INSERT INTO t1 VALUES(7, 'Lakshya7');
INSERT INTO t1 VALUES(58, 'Lakshya8');
INSERT INTO t1 VALUES(9, 'Lakshya9');
INSERT INTO t1 VALUES(10, 'Lakshya10');
COMMIT;
INSERT INTO t1 VALUES(11, 'Lakshya11');
INSERT INTO t1 VALUES(12, 'Kiran');
INSERT INTO t1 VALUES(69, 'Lakshya13');
INSERT INTO t1 VALUES(14, 'Lakshya14');
INSERT INTO t1 VALUES(15, 'Lakshya15');
INSERT INTO t1 VALUES(16, 'Lakshya16');
INSERT INTO t1 VALUES(31, 'Lakshya17');
INSERT INTO t1 VALUES(18, 'jitendra');
INSERT INTO t1 VALUES(19, 'Lakshya19');
INSERT INTO t1 VALUES(20, 'Lakshya20');
COMMIT;
INSERT INTO t1 VALUES(21, 'Lakshya21');
INSERT INTO t1 VALUES(72, 'suman');
INSERT INTO t1 VALUES(23, 'Lakshya23');
INSERT INTO t1 VALUES(24, 'Lakshya24');
INSERT INTO t1 VALUES(25, 'Lakshya25');
COMMIT;