exp.test004.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, 'Laxman72');
INSERT INTO t1 VALUES(73, 'Laxman73');
INSERT INTO t1 VALUES(74, 'Laxman74');
INSERT INTO t1 VALUES(456, 'Laxman75');
INSERT INTO t1 VALUES(76, 'Laxman76');
INSERT INTO t1 VALUES(77, 'Laxman77');
INSERT INTO t1 VALUES(78, 'Laxman78');
INSERT INTO t1 VALUES(79, 'Laxman79');
INSERT INTO t1 VALUES(80, 'Laxman80');
INSERT INTO t1 VALUES(81, 'Laxman81');
INSERT INTO t1 VALUES(82, 'Laxman82');
INSERT INTO t1 VALUES(40, 'Laxman40');
INSERT INTO t1 VALUES(41, 'Laxman41');
INSERT INTO t1 VALUES(42, 'Laxman42');
INSERT INTO t1 VALUES(43, 'Laxman43');
INSERT INTO t1 VALUES(44, 'Laxman44');
INSERT INTO t1 VALUES(45, 'Laxman45');
INSERT INTO t1 VALUES(46, 'Laxman46');
INSERT INTO t1 VALUES(47, 'Laxman47');
INSERT INTO t1 VALUES(18, 'Laxman18');
INSERT INTO t1 VALUES(555, 'Malaysia63');
INSERT INTO t1 VALUES(64, 'Laxman64');
INSERT INTO t1 VALUES(65, 'Laxman65');
INSERT INTO t1 VALUES(66, 'Laxman66');
INSERT INTO t1 VALUES(67, 'Laxman67');
INSERT INTO t1 VALUES(68, 'Laxman68');
INSERT INTO t1 VALUES(19, 'Laxman19');
INSERT INTO t1 VALUES(823, 'Laxman83');
INSERT INTO t1 VALUES(84, 'Laxman84');
COMMIT;
INSERT INTO t1 VALUES(85, 'Laxman85');
INSERT INTO t1 VALUES(11, 'Laxman11');
INSERT INTO t1 VALUES(12, 'Laxman12');
INSERT INTO t1 VALUES(13, 'Laxman13');
INSERT INTO t1 VALUES(14, 'Laxman14');
INSERT INTO t1 VALUES(15, 'Laxman15');
INSERT INTO t1 VALUES(16, 'Laxman16');
INSERT INTO t1 VALUES(17, 'Laxman17');
INSERT INTO t1 VALUES(530, 'Laxman30');
INSERT INTO t1 VALUES(31, 'Laxman31');
INSERT INTO t1 VALUES(32, 'Laxman32');
INSERT INTO t1 VALUES(33, 'Paris3');
INSERT INTO t1 VALUES(34, 'Laxman34');
INSERT INTO t1 VALUES(35, 'Laxman35');
INSERT INTO t1 VALUES(36, 'Pakistan');
INSERT INTO t1 VALUES(37, 'Laxman37');
INSERT INTO t1 VALUES(777, 'Laxman38');
INSERT INTO t1 VALUES(39, 'Laxman39');
INSERT INTO t1 VALUES(20, 'Laxman20');
INSERT INTO t1 VALUES(21, 'Laxman21');
INSERT INTO t1 VALUES(22, 'Laxman22');
INSERT INTO t1 VALUES(23, 'Laxman23');
INSERT INTO t1 VALUES(24, 'Laxman24');
INSERT INTO t1 VALUES(25, 'Laxman25');
INSERT INTO t1 VALUES(26, 'Laxman26');
INSERT INTO t1 VALUES(27, 'Laxman27');
INSERT INTO t1 VALUES(28, 'Laxman28');
INSERT INTO t1 VALUES(29, 'Laxman29');
INSERT INTO t1 VALUES(48, 'London');
INSERT INTO t1 VALUES(49, 'Laxman49');
COMMIT;
INSERT INTO t1 VALUES(50, 'Laxman50');
INSERT INTO t1 VALUES(51, 'Laxman51');
INSERT INTO t1 VALUES(142, 'Laxman52');
INSERT INTO t1 VALUES(53, 'Laxman53');
INSERT INTO t1 VALUES(54, 'Laxman54');
INSERT INTO t1 VALUES(55, 'Laxman55');
INSERT INTO t1 VALUES(56, 'Laxman56');
INSERT INTO t1 VALUES(90, 'Laxman90');
INSERT INTO t1 VALUES(91, 'Laxman91');
INSERT INTO t1 VALUES(92, 'Laxman92');
INSERT INTO t1 VALUES(93, 'Laxman93');
INSERT INTO t1 VALUES(94, 'Laxman94');
INSERT INTO t1 VALUES(95, 'Laxman95');
INSERT INTO t1 VALUES(96, 'Laxman96');
INSERT INTO t1 VALUES(97, 'Laxman97');
INSERT INTO t1 VALUES(98, 'Laxman98');
INSERT INTO t1 VALUES(99, 'Laxman99');
INSERT INTO t1 VALUES(1, 'Laxman1');
INSERT INTO t1 VALUES(2, 'Laxman2');
INSERT INTO t1 VALUES(3, 'Laxman3');
INSERT INTO t1 VALUES(4, 'Laxman4');
INSERT INTO t1 VALUES(5, 'Laxman5');
INSERT INTO t1 VALUES(6, 'Laxman6');
INSERT INTO t1 VALUES(7, 'Laxman7');
INSERT INTO t1 VALUES(8, 'Laxman8');
INSERT INTO t1 VALUES(9, 'Laxman9');
INSERT INTO t1 VALUES(10, 'Laxman10');
INSERT INTO t1 VALUES(57, 'Laxman57');
INSERT INTO t1 VALUES(58, 'Laxman58');
INSERT INTO t1 VALUES(59, 'Laxman59');
COMMIT;
INSERT INTO t1 VALUES(60, 'Laxman60');
INSERT INTO t1 VALUES(61, 'Laxman61');
INSERT INTO t1 VALUES(62, 'Laxman62');
INSERT INTO t1 VALUES(69, 'Laxman69');
INSERT INTO t1 VALUES(70, 'Laxman70');
INSERT INTO t1 VALUES(86, 'Laxman86');
INSERT INTO t1 VALUES(87, 'Laxman87');
INSERT INTO t1 VALUES(88, 'Laxman88');
INSERT INTO t1 VALUES(89, 'Laxman89');
COMMIT;