exp.test005.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(123, 'india');
INSERT INTO t1 VALUES(72, 'Laxwoman72');
INSERT INTO t1 VALUES(25, 'Laxwoman25');
INSERT INTO t1 VALUES(77, 'Laxwoman77');
INSERT INTO t1 VALUES(78, 'Laxwoman78');
INSERT INTO t1 VALUES(79, 'Laxwoman79');
INSERT INTO t1 VALUES(80, 'Laxwoman80');
INSERT INTO t1 VALUES(26, 'Laxwoman26');
INSERT INTO t1 VALUES(27, 'Laxwoman27');
INSERT INTO t1 VALUES(28, 'Laxwoman28');
INSERT INTO t1 VALUES(29, 'Laxwoman29');
INSERT INTO t1 VALUES(48, 'London');
INSERT INTO t1 VALUES(49, 'Laxwoman49');
INSERT INTO t1 VALUES(50, 'Laxwoman50');
INSERT INTO t1 VALUES(51, 'Laxwoman51');
INSERT INTO t1 VALUES(142, 'Laxwoman52');
INSERT INTO t1 VALUES(53, 'Laxwoman53');
INSERT INTO t1 VALUES(54, 'Laxwoman54');
INSERT INTO t1 VALUES(55, 'Laxwoman55');
INSERT INTO t1 VALUES(56, 'Laxwoman56');
INSERT INTO t1 VALUES(90, 'Laxwoman90');
INSERT INTO t1 VALUES(91, 'Laxwoman91');
INSERT INTO t1 VALUES(92, 'Laxwoman92');
INSERT INTO t1 VALUES(93, 'Laxwoman93');
INSERT INTO t1 VALUES(94, 'Laxwoman94');
COMMIT;
INSERT INTO t1 VALUES(95, 'Laxwoman95');
INSERT INTO t1 VALUES(73, 'Laxwoman73');
INSERT INTO t1 VALUES(74, 'Laxwoman74');
INSERT INTO t1 VALUES(456, 'Laxwoman75');
INSERT INTO t1 VALUES(76, 'Laxwoman76');
INSERT INTO t1 VALUES(81, 'Laxwoman81');
INSERT INTO t1 VALUES(82, 'Laxwoman82');
INSERT INTO t1 VALUES(40, 'Laxwoman40');
INSERT INTO t1 VALUES(41, 'Laxwoman41');
INSERT INTO t1 VALUES(42, 'Laxwoman42');
INSERT INTO t1 VALUES(43, 'Laxwoman43');
INSERT INTO t1 VALUES(44, 'Laxwoman44');
INSERT INTO t1 VALUES(45, 'Laxwoman45');
INSERT INTO t1 VALUES(46, 'Laxwoman46');
INSERT INTO t1 VALUES(47, 'Laxwoman47');
INSERT INTO t1 VALUES(18, 'Laxwoman18');
INSERT INTO t1 VALUES(555, 'Malaysia63');
INSERT INTO t1 VALUES(64, 'Laxwoman64');
INSERT INTO t1 VALUES(65, 'Laxwoman65');
INSERT INTO t1 VALUES(66, 'Laxwoman66');
INSERT INTO t1 VALUES(67, 'Laxwoman67');
INSERT INTO t1 VALUES(68, 'Laxwoman68');
INSERT INTO t1 VALUES(19, 'Laxwoman19');
INSERT INTO t1 VALUES(823, 'Laxwoman83');
INSERT INTO t1 VALUES(84, 'Laxwoman84');
COMMIT;
INSERT INTO t1 VALUES(85, 'Laxwoman85');
INSERT INTO t1 VALUES(11, 'Laxwoman11');
INSERT INTO t1 VALUES(12, 'Laxwoman12');
INSERT INTO t1 VALUES(13, 'Laxwoman13');
INSERT INTO t1 VALUES(14, 'Laxwoman14');
INSERT INTO t1 VALUES(15, 'Laxwoman15');
INSERT INTO t1 VALUES(16, 'Laxwoman16');
INSERT INTO t1 VALUES(17, 'Laxwoman17');
INSERT INTO t1 VALUES(530, 'Laxwoman30');
INSERT INTO t1 VALUES(31, 'Laxwoman31');
INSERT INTO t1 VALUES(32, 'Laxwoman32');
INSERT INTO t1 VALUES(33, 'Paris3');
INSERT INTO t1 VALUES(34, 'Laxwoman34');
INSERT INTO t1 VALUES(35, 'Laxwoman35');
INSERT INTO t1 VALUES(36, 'Pakistan');
INSERT INTO t1 VALUES(37, 'Laxwoman37');
INSERT INTO t1 VALUES(777, 'Laxwoman38');
INSERT INTO t1 VALUES(39, 'Laxwoman39');
INSERT INTO t1 VALUES(20, 'Laxwoman20');
INSERT INTO t1 VALUES(21, 'Laxwoman21');
INSERT INTO t1 VALUES(22, 'Laxwoman22');
INSERT INTO t1 VALUES(23, 'Laxwoman23');
INSERT INTO t1 VALUES(24, 'Laxwoman24');
INSERT INTO t1 VALUES(96, 'Laxwoman96');
INSERT INTO t1 VALUES(97, 'Laxwoman97');
COMMIT;
INSERT INTO t1 VALUES(98, 'Laxwoman98');
INSERT INTO t1 VALUES(1, 'Laxwoman1');
INSERT INTO t1 VALUES(2, 'Laxwoman2');
INSERT INTO t1 VALUES(3, 'Laxwoman3');
INSERT INTO t1 VALUES(4, 'Laxwoman4');
INSERT INTO t1 VALUES(5, 'Laxwoman5');
INSERT INTO t1 VALUES(6, 'Laxwoman6');
INSERT INTO t1 VALUES(7, 'Laxwoman7');
INSERT INTO t1 VALUES(8, 'Laxwoman8');
INSERT INTO t1 VALUES(9, 'Laxwoman9');
INSERT INTO t1 VALUES(10, 'Laxwoman10');
INSERT INTO t1 VALUES(57, 'Laxwoman57');
INSERT INTO t1 VALUES(58, 'Laxwoman58');
INSERT INTO t1 VALUES(59, 'Laxwoman59');
INSERT INTO t1 VALUES(60, 'Laxwoman60');
INSERT INTO t1 VALUES(61, 'Laxwoman61');
INSERT INTO t1 VALUES(62, 'Laxwoman62');
INSERT INTO t1 VALUES(69, 'Laxwoman69');
INSERT INTO t1 VALUES(70, 'Laxwoman70');
INSERT INTO t1 VALUES(86, 'Laxwoman86');
INSERT INTO t1 VALUES(87, 'Laxwoman87');
INSERT INTO t1 VALUES(88, 'Laxwoman88');
INSERT INTO t1 VALUES(89, 'Laxwoman89');
INSERT INTO t1 VALUES(1189, 'Laxwoman89');
INSERT INTO t1 VALUES(2289, 'Laxwoman89');
COMMIT;
INSERT INTO t1 VALUES(3389, 'Laxwoman89');
COMMIT;