exp.test003.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, 'Lakshya72');
INSERT INTO t1 VALUES(73, 'Lakshya73');
INSERT INTO t1 VALUES(74, 'Lakshya74');
INSERT INTO t1 VALUES(456, 'Lakshya75');
INSERT INTO t1 VALUES(76, 'Lakshya76');
INSERT INTO t1 VALUES(77, 'Lakshya77');
INSERT INTO t1 VALUES(78, 'Lakshya78');
INSERT INTO t1 VALUES(79, 'Lakshya79');
INSERT INTO t1 VALUES(80, 'Lakshya80');
INSERT INTO t1 VALUES(81, 'Lakshya81');
INSERT INTO t1 VALUES(82, 'Lakshya82');
INSERT INTO t1 VALUES(40, 'Lakshya40');
INSERT INTO t1 VALUES(41, 'Lakshya41');
INSERT INTO t1 VALUES(42, 'Lakshya42');
INSERT INTO t1 VALUES(43, 'Lakshya43');
INSERT INTO t1 VALUES(44, 'Lakshya44');
INSERT INTO t1 VALUES(45, 'Lakshya45');
INSERT INTO t1 VALUES(46, 'Lakshya46');
INSERT INTO t1 VALUES(47, 'Lakshya47');
COMMIT;
INSERT INTO t1 VALUES(18, 'Lakshya18');
INSERT INTO t1 VALUES(555, 'Malaysia63');
INSERT INTO t1 VALUES(64, 'Lakshya64');
INSERT INTO t1 VALUES(65, 'Lakshya65');
INSERT INTO t1 VALUES(66, 'Lakshya66');
INSERT INTO t1 VALUES(67, 'Lakshya67');
INSERT INTO t1 VALUES(68, 'Lakshya68');
INSERT INTO t1 VALUES(19, 'Lakshya19');
INSERT INTO t1 VALUES(823, 'Lakshya83');
INSERT INTO t1 VALUES(84, 'Lakshya84');
INSERT INTO t1 VALUES(85, 'Lakshya85');
INSERT INTO t1 VALUES(11, 'Lakshya11');
INSERT INTO t1 VALUES(12, 'Lakshya12');
INSERT INTO t1 VALUES(13, 'Lakshya13');
INSERT INTO t1 VALUES(14, 'Lakshya14');
INSERT INTO t1 VALUES(15, 'Lakshya15');
INSERT INTO t1 VALUES(16, 'Lakshya16');
INSERT INTO t1 VALUES(17, 'Lakshya17');
INSERT INTO t1 VALUES(530, 'Lakshya30');
INSERT INTO t1 VALUES(31, 'Lakshya31');
COMMIT;
INSERT INTO t1 VALUES(32, 'Lakshya32');
INSERT INTO t1 VALUES(33, 'Lakshya33');
INSERT INTO t1 VALUES(34, 'Lakshya34');
INSERT INTO t1 VALUES(35, 'Lakshya35');
INSERT INTO t1 VALUES(36, 'Pakistan');
INSERT INTO t1 VALUES(37, 'Lakshya37');
INSERT INTO t1 VALUES(777, 'Lakshya38');
INSERT INTO t1 VALUES(39, 'Lakshya39');
INSERT INTO t1 VALUES(20, 'Lakshya20');
INSERT INTO t1 VALUES(21, 'Lakshya21');
INSERT INTO t1 VALUES(22, 'Lakshya22');
INSERT INTO t1 VALUES(23, 'Lakshya23');
INSERT INTO t1 VALUES(24, 'Lakshya24');
INSERT INTO t1 VALUES(25, 'Lakshya25');
INSERT INTO t1 VALUES(26, 'Lakshya26');
INSERT INTO t1 VALUES(27, 'Lakshya27');
INSERT INTO t1 VALUES(28, 'Lakshya28');
INSERT INTO t1 VALUES(29, 'Lakshya29');
INSERT INTO t1 VALUES(48, 'Lakshya48');
INSERT INTO t1 VALUES(49, 'Lakshya49');
COMMIT;
INSERT INTO t1 VALUES(50, 'Lakshya50');
INSERT INTO t1 VALUES(51, 'Lakshya51');
INSERT INTO t1 VALUES(142, 'Lakshya52');
INSERT INTO t1 VALUES(53, 'Lakshya53');
INSERT INTO t1 VALUES(54, 'Lakshya54');
INSERT INTO t1 VALUES(55, 'Lakshya55');
INSERT INTO t1 VALUES(56, 'Lakshya56');
INSERT INTO t1 VALUES(90, 'Lakshya90');
INSERT INTO t1 VALUES(91, 'Lakshya91');
INSERT INTO t1 VALUES(92, 'Lakshya92');
INSERT INTO t1 VALUES(93, 'Lakshya93');
INSERT INTO t1 VALUES(94, 'Lakshya94');
INSERT INTO t1 VALUES(95, 'Lakshya95');
INSERT INTO t1 VALUES(96, 'Lakshya96');
INSERT INTO t1 VALUES(97, 'Lakshya97');
INSERT INTO t1 VALUES(98, 'Lakshya98');
INSERT INTO t1 VALUES(99, 'Lakshya99');
INSERT INTO t1 VALUES(100, 'Lakshya100');
INSERT INTO t1 VALUES(1, 'Lakshya1');
INSERT INTO t1 VALUES(2, 'Lakshya2');
COMMIT;
INSERT INTO t1 VALUES(3, 'Lakshya3');
INSERT INTO t1 VALUES(4, 'Lakshya4');
INSERT INTO t1 VALUES(5, 'Lakshya5');
INSERT INTO t1 VALUES(6, 'Lakshya6');
INSERT INTO t1 VALUES(7, 'Lakshya7');
INSERT INTO t1 VALUES(8, 'Lakshya8');
INSERT INTO t1 VALUES(9, 'Lakshya9');
INSERT INTO t1 VALUES(10, 'Lakshya10');
INSERT INTO t1 VALUES(57, 'Lakshya57');
INSERT INTO t1 VALUES(58, 'Lakshya58');
INSERT INTO t1 VALUES(59, 'Lakshya59');
INSERT INTO t1 VALUES(60, 'Lakshya60');
INSERT INTO t1 VALUES(61, 'Lakshya61');
INSERT INTO t1 VALUES(62, 'Lakshya62');
INSERT INTO t1 VALUES(69, 'Lakshya69');
INSERT INTO t1 VALUES(70, 'Lakshya70');
INSERT INTO t1 VALUES(86, 'Lakshya86');
INSERT INTO t1 VALUES(87, 'Lakshya87');
INSERT INTO t1 VALUES(88, 'Lakshya88');
INSERT INTO t1 VALUES(89, 'Lakshya89');
COMMIT;