exp.test012.ksh

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

CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT );
CREATE INDEX t1_idx1_Primary on t1 ( f1 )  UNIQUE;
SET AUTOCOMMIT OFF;
INSERT INTO t1 VALUES(0,1);
INSERT INTO t1 VALUES(1,11);
INSERT INTO t1 VALUES(2,21);
INSERT INTO t1 VALUES(3,31);
INSERT INTO t1 VALUES(4,41);
INSERT INTO t1 VALUES(5,51);
INSERT INTO t1 VALUES(6,61);
INSERT INTO t1 VALUES(7,71);
INSERT INTO t1 VALUES(8,81);
INSERT INTO t1 VALUES(9,91);
INSERT INTO t1 VALUES(10,101);
INSERT INTO t1 VALUES(11,111);
INSERT INTO t1 VALUES(12,121);
INSERT INTO t1 VALUES(13,131);
INSERT INTO t1 VALUES(14,141);
INSERT INTO t1 VALUES(15,151);
INSERT INTO t1 VALUES(16,161);
INSERT INTO t1 VALUES(17,171);
INSERT INTO t1 VALUES(18,181);
INSERT INTO t1 VALUES(19,191);
INSERT INTO t1 VALUES(20,201);
INSERT INTO t1 VALUES(21,211);
INSERT INTO t1 VALUES(22,221);
INSERT INTO t1 VALUES(23,231);
INSERT INTO t1 VALUES(24,241);
COMMIT;
INSERT INTO t1 VALUES(25,251);
INSERT INTO t1 VALUES(26,261);
INSERT INTO t1 VALUES(27,271);
INSERT INTO t1 VALUES(28,281);
INSERT INTO t1 VALUES(29,291);
INSERT INTO t1 VALUES(30,301);
INSERT INTO t1 VALUES(31,311);
INSERT INTO t1 VALUES(32,321);
INSERT INTO t1 VALUES(33,331);
INSERT INTO t1 VALUES(34,341);
INSERT INTO t1 VALUES(35,351);
INSERT INTO t1 VALUES(36,361);
INSERT INTO t1 VALUES(37,371);
INSERT INTO t1 VALUES(38,381);
INSERT INTO t1 VALUES(39,391);
INSERT INTO t1 VALUES(40,401);
INSERT INTO t1 VALUES(41,411);
INSERT INTO t1 VALUES(42,421);
INSERT INTO t1 VALUES(43,431);
INSERT INTO t1 VALUES(44,441);
INSERT INTO t1 VALUES(45,451);
INSERT INTO t1 VALUES(46,461);
INSERT INTO t1 VALUES(47,471);
INSERT INTO t1 VALUES(48,481);
INSERT INTO t1 VALUES(49,491);
COMMIT;
INSERT INTO t1 VALUES(50,501);
INSERT INTO t1 VALUES(51,511);
INSERT INTO t1 VALUES(52,521);
INSERT INTO t1 VALUES(53,531);
INSERT INTO t1 VALUES(54,541);
INSERT INTO t1 VALUES(55,551);
INSERT INTO t1 VALUES(56,561);
INSERT INTO t1 VALUES(57,571);
INSERT INTO t1 VALUES(58,581);
INSERT INTO t1 VALUES(59,591);
INSERT INTO t1 VALUES(60,601);
INSERT INTO t1 VALUES(61,611);
INSERT INTO t1 VALUES(62,621);
INSERT INTO t1 VALUES(63,631);
INSERT INTO t1 VALUES(64,641);
INSERT INTO t1 VALUES(65,651);
INSERT INTO t1 VALUES(66,661);
INSERT INTO t1 VALUES(67,671);
INSERT INTO t1 VALUES(68,681);
INSERT INTO t1 VALUES(69,691);
INSERT INTO t1 VALUES(70,701);
INSERT INTO t1 VALUES(71,711);
INSERT INTO t1 VALUES(72,721);
INSERT INTO t1 VALUES(73,731);
INSERT INTO t1 VALUES(74,741);
COMMIT;
INSERT INTO t1 VALUES(75,751);
INSERT INTO t1 VALUES(76,761);
INSERT INTO t1 VALUES(77,771);
INSERT INTO t1 VALUES(78,781);
INSERT INTO t1 VALUES(79,791);
INSERT INTO t1 VALUES(80,801);
INSERT INTO t1 VALUES(81,811);
INSERT INTO t1 VALUES(82,821);
INSERT INTO t1 VALUES(83,831);
INSERT INTO t1 VALUES(84,841);
INSERT INTO t1 VALUES(85,851);
INSERT INTO t1 VALUES(86,861);
INSERT INTO t1 VALUES(87,871);
INSERT INTO t1 VALUES(88,881);
INSERT INTO t1 VALUES(89,891);
INSERT INTO t1 VALUES(90,901);
INSERT INTO t1 VALUES(91,911);
INSERT INTO t1 VALUES(92,921);
INSERT INTO t1 VALUES(93,931);
INSERT INTO t1 VALUES(94,941);
INSERT INTO t1 VALUES(95,951);
INSERT INTO t1 VALUES(96,961);
INSERT INTO t1 VALUES(97,971);
INSERT INTO t1 VALUES(98,981);
INSERT INTO t1 VALUES(99,991);
COMMIT;
INSERT INTO t1 VALUES(100,1001);
INSERT INTO t1 VALUES(101,1011);
INSERT INTO t1 VALUES(102,1021);
INSERT INTO t1 VALUES(103,1031);
INSERT INTO t1 VALUES(104,1041);
INSERT INTO t1 VALUES(105,1051);
INSERT INTO t1 VALUES(106,1061);
INSERT INTO t1 VALUES(107,1071);
INSERT INTO t1 VALUES(108,1081);
INSERT INTO t1 VALUES(109,1091);
INSERT INTO t1 VALUES(110,1101);
INSERT INTO t1 VALUES(111,1111);
INSERT INTO t1 VALUES(112,1121);
INSERT INTO t1 VALUES(113,1131);
INSERT INTO t1 VALUES(114,1141);
INSERT INTO t1 VALUES(115,1151);
INSERT INTO t1 VALUES(116,1161);
INSERT INTO t1 VALUES(117,1171);
INSERT INTO t1 VALUES(118,1181);
INSERT INTO t1 VALUES(119,1191);
INSERT INTO t1 VALUES(120,1201);
INSERT INTO t1 VALUES(121,1211);
INSERT INTO t1 VALUES(122,1221);
INSERT INTO t1 VALUES(123,1231);
INSERT INTO t1 VALUES(124,1241);
COMMIT;
INSERT INTO t1 VALUES(125,1251);
INSERT INTO t1 VALUES(126,1261);
INSERT INTO t1 VALUES(127,1271);
INSERT INTO t1 VALUES(128,1281);
INSERT INTO t1 VALUES(129,1291);
INSERT INTO t1 VALUES(130,1301);
INSERT INTO t1 VALUES(131,1311);
INSERT INTO t1 VALUES(132,1321);
INSERT INTO t1 VALUES(133,1331);
INSERT INTO t1 VALUES(134,1341);
INSERT INTO t1 VALUES(135,1351);
INSERT INTO t1 VALUES(136,1361);
INSERT INTO t1 VALUES(137,1371);
INSERT INTO t1 VALUES(138,1381);
INSERT INTO t1 VALUES(139,1391);
INSERT INTO t1 VALUES(140,1401);
INSERT INTO t1 VALUES(141,1411);
INSERT INTO t1 VALUES(142,1421);
INSERT INTO t1 VALUES(143,1431);
INSERT INTO t1 VALUES(144,1441);
INSERT INTO t1 VALUES(145,1451);
INSERT INTO t1 VALUES(146,1461);
INSERT INTO t1 VALUES(147,1471);
INSERT INTO t1 VALUES(148,1481);
INSERT INTO t1 VALUES(149,1491);
COMMIT;
INSERT INTO t1 VALUES(150,1501);
INSERT INTO t1 VALUES(151,1511);
INSERT INTO t1 VALUES(152,1521);
INSERT INTO t1 VALUES(153,1531);
INSERT INTO t1 VALUES(154,1541);
INSERT INTO t1 VALUES(155,1551);
INSERT INTO t1 VALUES(156,1561);
COMMIT;