1set default_storage_engine='tokudb'; 2DROP TABLE IF EXISTS t; 3CREATE TABLE t (a INT NOT NULL AUTO_INCREMENT, b INT, PRIMARY KEY(a), CLUSTERING KEY b(b)) ENGINE=TokuDB 4PARTITION BY RANGE(a) (PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB, PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = TokuDB); 5SHOW CREATE TABLE t; 6Table Create Table 7t CREATE TABLE `t` ( 8 `a` int(11) NOT NULL AUTO_INCREMENT, 9 `b` int(11) DEFAULT NULL, 10 PRIMARY KEY (`a`), 11 CLUSTERING KEY `b` (`b`) 12) ENGINE=TokuDB DEFAULT CHARSET=latin1 13/*!50100 PARTITION BY RANGE (a) 14(PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB, 15 PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = TokuDB) */ 16DROP TABLE t; 17CREATE TABLE t (x INT NOT NULL, y INT NOT NULL, PRIMARY KEY(x)) 18PARTITION BY HASH(x) PARTITIONS 2; 19SHOW CREATE TABLE t; 20Table Create Table 21t CREATE TABLE `t` ( 22 `x` int(11) NOT NULL, 23 `y` int(11) NOT NULL, 24 PRIMARY KEY (`x`) 25) ENGINE=TokuDB DEFAULT CHARSET=latin1 26 PARTITION BY HASH (x) 27PARTITIONS 2 28ALTER TABLE t ADD CLUSTERING KEY(y); 29SHOW CREATE TABLE t; 30Table Create Table 31t CREATE TABLE `t` ( 32 `x` int(11) NOT NULL, 33 `y` int(11) NOT NULL, 34 PRIMARY KEY (`x`), 35 CLUSTERING KEY `y` (`y`) 36) ENGINE=TokuDB DEFAULT CHARSET=latin1 37 PARTITION BY HASH (x) 38PARTITIONS 2 39DROP TABLE t; 40CREATE TABLE t1(a INT, b INT, c INT, d INT, PRIMARY KEY(a,b,c), CLUSTERING KEY(b), KEY (c)) ENGINE=TOKUDB 41PARTITION BY RANGE(a) (PARTITION p0 VALUES LESS THAN (5) ENGINE = TOKUDB, PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = TOKUDB); 42insert into t1 values (1,10,100,1000),(2,20,200,2000),(3,30,300,3000),(4,40,400,4000),(5,50,500,5000),(6,60,600,6000),(7,70,700,7000),(8,80,800,8000),(9,90,900,9000); 43explain select * from t1 where a > 5; 44id select_type table type possible_keys key key_len ref rows Extra 451 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where 46select * from t1 where a > 5; 47a b c d 486 60 600 6000 497 70 700 7000 508 80 800 8000 519 90 900 9000 52explain select * from t1 where b > 30; 53id select_type table type possible_keys key key_len ref rows Extra 541 SIMPLE t1 range b b 4 NULL NULL; Using where 55select * from t1 where b > 30; 56a b c d 574 40 400 4000 585 50 500 5000 596 60 600 6000 607 70 700 7000 618 80 800 8000 629 90 900 9000 63explain select * from t1 where c > 750; 64id select_type table type possible_keys key key_len ref rows Extra 651 SIMPLE t1 range c c 4 NULL NULL; Using where 66select * from t1 where c > 750; 67a b c d 688 80 800 8000 699 90 900 9000 70explain select a from t1 where a > 8; 71id select_type table type possible_keys key key_len ref rows Extra 721 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index 73select a from t1 where a > 8; 74a 759 76explain select a,b from t1 where b > 30; 77id select_type table type possible_keys key key_len ref rows Extra 781 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 79select a,b from t1 where b > 30; 80a b 814 40 825 50 836 60 847 70 858 80 869 90 87explain select a,b from t1 where c > 750; 88id select_type table type possible_keys key key_len ref rows Extra 891 SIMPLE t1 index c b 4 NULL NULL; Using where; Using index 90select a,c from t1 where c > 750; 91a c 928 800 939 900 94alter table t1 add clustering index bdca(b,d,c,a); 95insert into t1 values (10,10,10,10); 96alter table t1 drop index bdca; 97alter table t1 drop primary key; 98explain select * from t1 where a > 5; 99id select_type table type possible_keys key key_len ref rows Extra 1001 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where 101select * from t1 where a > 5; 102a b c d 1036 60 600 6000 1047 70 700 7000 1058 80 800 8000 1069 90 900 9000 10710 10 10 10 108explain select * from t1 where b > 30; 109id select_type table type possible_keys key key_len ref rows Extra 1101 SIMPLE t1 range b b 4 NULL NULL; Using where 111select * from t1 where b > 30; 112a b c d 1134 40 400 4000 1145 50 500 5000 1156 60 600 6000 1167 70 700 7000 1178 80 800 8000 1189 90 900 9000 119explain select * from t1 where c > 750; 120id select_type table type possible_keys key key_len ref rows Extra 1211 SIMPLE t1 range c c 4 NULL NULL; Using where 122select * from t1 where c > 750; 123a b c d 1248 80 800 8000 1259 90 900 9000 126explain select b from t1 where b > 30; 127id select_type table type possible_keys key key_len ref rows Extra 1281 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 129select b from t1 where b > 30; 130b 13140 13250 13360 13470 13580 13690 137explain select b from t1 where c > 750; 138id select_type table type possible_keys key key_len ref rows Extra 1391 SIMPLE t1 range c c 4 NULL NULL; Using where 140select c from t1 where c > 750; 141c 142800 143900 144alter table t1 add e varchar(20); 145alter table t1 add primary key (a,b,c); 146explain select * from t1 where a > 5; 147id select_type table type possible_keys key key_len ref rows Extra 1481 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where 149select * from t1 where a > 5; 150a b c d e 1516 60 600 6000 NULL 1527 70 700 7000 NULL 1538 80 800 8000 NULL 1549 90 900 9000 NULL 15510 10 10 10 NULL 156explain select * from t1 where b > 30; 157id select_type table type possible_keys key key_len ref rows Extra 1581 SIMPLE t1 range b b 4 NULL NULL; Using where 159select * from t1 where b > 30; 160a b c d e 1614 40 400 4000 NULL 1625 50 500 5000 NULL 1636 60 600 6000 NULL 1647 70 700 7000 NULL 1658 80 800 8000 NULL 1669 90 900 9000 NULL 167explain select * from t1 where c > 750; 168id select_type table type possible_keys key key_len ref rows Extra 1691 SIMPLE t1 range c c 4 NULL NULL; Using where 170select * from t1 where c > 750; 171a b c d e 1728 80 800 8000 NULL 1739 90 900 9000 NULL 174explain select a from t1 where a > 8; 175id select_type table type possible_keys key key_len ref rows Extra 1761 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index 177select a from t1 where a > 8; 178a 1799 18010 181explain select a,b from t1 where b > 30; 182id select_type table type possible_keys key key_len ref rows Extra 1831 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 184select a,b from t1 where b > 30; 185a b 1864 40 1875 50 1886 60 1897 70 1908 80 1919 90 192explain select a,b from t1 where c > 750; 193id select_type table type possible_keys key key_len ref rows Extra 1941 SIMPLE t1 range c c 4 NULL NULL; Using where; Using index 195select a,c from t1 where c > 750; 196a c 1978 800 1989 900 199alter table t1 drop primary key; 200explain select * from t1 where a > 5; 201id select_type table type possible_keys key key_len ref rows Extra 2021 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where 203select * from t1 where a > 5; 204a b c d e 2056 60 600 6000 NULL 2067 70 700 7000 NULL 2078 80 800 8000 NULL 2089 90 900 9000 NULL 20910 10 10 10 NULL 210explain select * from t1 where b > 30; 211id select_type table type possible_keys key key_len ref rows Extra 2121 SIMPLE t1 range b b 4 NULL NULL; Using where 213select * from t1 where b > 30; 214a b c d e 2154 40 400 4000 NULL 2165 50 500 5000 NULL 2176 60 600 6000 NULL 2187 70 700 7000 NULL 2198 80 800 8000 NULL 2209 90 900 9000 NULL 221explain select * from t1 where c > 750; 222id select_type table type possible_keys key key_len ref rows Extra 2231 SIMPLE t1 range c c 4 NULL NULL; Using where 224select * from t1 where c > 750; 225a b c d e 2268 80 800 8000 NULL 2279 90 900 9000 NULL 228explain select b from t1 where b > 30; 229id select_type table type possible_keys key key_len ref rows Extra 2301 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 231select b from t1 where b > 30; 232b 23340 23450 23560 23670 23780 23890 239explain select b from t1 where c > 750; 240id select_type table type possible_keys key key_len ref rows Extra 2411 SIMPLE t1 range c c 4 NULL NULL; Using where 242select c from t1 where c > 750; 243c 244800 245900 246DROP TABLE t1; 247CREATE TABLE t1(a INT, b INT, c INT, d INT, PRIMARY KEY(a,b,c), CLUSTERING KEY(b), KEY (c)) ENGINE=TOKUDB 248PARTITION BY RANGE(b) (PARTITION p0 VALUES LESS THAN (50) ENGINE = TOKUDB, PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = TOKUDB); 249insert into t1 values (1,10,100,1000),(2,20,200,2000),(3,30,300,3000),(4,40,400,4000),(5,50,500,5000),(6,60,600,6000),(7,70,700,7000),(8,80,800,8000),(9,90,900,9000); 250explain select * from t1 where a > 5; 251id select_type table type possible_keys key key_len ref rows Extra 2521 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where 253select * from t1 where a > 5; 254a b c d 2556 60 600 6000 2567 70 700 7000 2578 80 800 8000 2589 90 900 9000 259explain select * from t1 where b > 30; 260id select_type table type possible_keys key key_len ref rows Extra 2611 SIMPLE t1 range b b 4 NULL NULL; Using where 262select * from t1 where b > 30; 263a b c d 2644 40 400 4000 2655 50 500 5000 2666 60 600 6000 2677 70 700 7000 2688 80 800 8000 2699 90 900 9000 270explain select * from t1 where c > 750; 271id select_type table type possible_keys key key_len ref rows Extra 2721 SIMPLE t1 range c c 4 NULL NULL; Using where 273select * from t1 where c > 750; 274a b c d 2758 80 800 8000 2769 90 900 9000 277explain select a from t1 where a > 8; 278id select_type table type possible_keys key key_len ref rows Extra 2791 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index 280select a from t1 where a > 8; 281a 2829 283explain select a,b from t1 where b > 30; 284id select_type table type possible_keys key key_len ref rows Extra 2851 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 286select a,b from t1 where b > 30; 287a b 2884 40 2895 50 2906 60 2917 70 2928 80 2939 90 294explain select a,b from t1 where c > 750; 295id select_type table type possible_keys key key_len ref rows Extra 2961 SIMPLE t1 index c b 4 NULL NULL; Using where; Using index 297select a,c from t1 where c > 750; 298a c 2998 800 3009 900 301alter table t1 add clustering index bdca(b,d,c,a); 302insert into t1 values (10,10,10,10); 303alter table t1 drop index bdca; 304alter table t1 drop primary key; 305explain select * from t1 where a > 5; 306id select_type table type possible_keys key key_len ref rows Extra 3071 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where 308select * from t1 where a > 5; 309a b c d 31010 10 10 10 3116 60 600 6000 3127 70 700 7000 3138 80 800 8000 3149 90 900 9000 315explain select * from t1 where b > 30; 316id select_type table type possible_keys key key_len ref rows Extra 3171 SIMPLE t1 range b b 4 NULL NULL; Using where 318select * from t1 where b > 30; 319a b c d 3204 40 400 4000 3215 50 500 5000 3226 60 600 6000 3237 70 700 7000 3248 80 800 8000 3259 90 900 9000 326explain select * from t1 where c > 750; 327id select_type table type possible_keys key key_len ref rows Extra 3281 SIMPLE t1 range c c 4 NULL NULL; Using where 329select * from t1 where c > 750; 330a b c d 3318 80 800 8000 3329 90 900 9000 333explain select b from t1 where b > 30; 334id select_type table type possible_keys key key_len ref rows Extra 3351 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 336select b from t1 where b > 30; 337b 33840 33950 34060 34170 34280 34390 344explain select b from t1 where c > 750; 345id select_type table type possible_keys key key_len ref rows Extra 3461 SIMPLE t1 range c c 4 NULL NULL; Using where 347select c from t1 where c > 750; 348c 349800 350900 351alter table t1 add e varchar(20); 352alter table t1 add primary key (a,b,c); 353explain select * from t1 where a > 5; 354id select_type table type possible_keys key key_len ref rows Extra 3551 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where 356select * from t1 where a > 5; 357a b c d e 35810 10 10 10 NULL 3596 60 600 6000 NULL 3607 70 700 7000 NULL 3618 80 800 8000 NULL 3629 90 900 9000 NULL 363explain select * from t1 where b > 30; 364id select_type table type possible_keys key key_len ref rows Extra 3651 SIMPLE t1 range b b 4 NULL NULL; Using where 366select * from t1 where b > 30; 367a b c d e 3684 40 400 4000 NULL 3695 50 500 5000 NULL 3706 60 600 6000 NULL 3717 70 700 7000 NULL 3728 80 800 8000 NULL 3739 90 900 9000 NULL 374explain select * from t1 where c > 750; 375id select_type table type possible_keys key key_len ref rows Extra 3761 SIMPLE t1 range c c 4 NULL NULL; Using where 377select * from t1 where c > 750; 378a b c d e 3798 80 800 8000 NULL 3809 90 900 9000 NULL 381explain select a from t1 where a > 8; 382id select_type table type possible_keys key key_len ref rows Extra 3831 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index 384select a from t1 where a > 8; 385a 38610 3879 388explain select a,b from t1 where b > 30; 389id select_type table type possible_keys key key_len ref rows Extra 3901 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 391select a,b from t1 where b > 30; 392a b 3934 40 3945 50 3956 60 3967 70 3978 80 3989 90 399explain select a,b from t1 where c > 750; 400id select_type table type possible_keys key key_len ref rows Extra 4011 SIMPLE t1 index c b 4 NULL NULL; Using where; Using index 402select a,c from t1 where c > 750; 403a c 4048 800 4059 900 406alter table t1 drop primary key; 407explain select * from t1 where a > 5; 408id select_type table type possible_keys key key_len ref rows Extra 4091 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where 410select * from t1 where a > 5; 411a b c d e 41210 10 10 10 NULL 4136 60 600 6000 NULL 4147 70 700 7000 NULL 4158 80 800 8000 NULL 4169 90 900 9000 NULL 417explain select * from t1 where b > 30; 418id select_type table type possible_keys key key_len ref rows Extra 4191 SIMPLE t1 range b b 4 NULL NULL; Using where 420select * from t1 where b > 30; 421a b c d e 4224 40 400 4000 NULL 4235 50 500 5000 NULL 4246 60 600 6000 NULL 4257 70 700 7000 NULL 4268 80 800 8000 NULL 4279 90 900 9000 NULL 428explain select * from t1 where c > 750; 429id select_type table type possible_keys key key_len ref rows Extra 4301 SIMPLE t1 range c c 4 NULL NULL; Using where 431select * from t1 where c > 750; 432a b c d e 4338 80 800 8000 NULL 4349 90 900 9000 NULL 435explain select b from t1 where b > 30; 436id select_type table type possible_keys key key_len ref rows Extra 4371 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 438select b from t1 where b > 30; 439b 44040 44150 44260 44370 44480 44590 446explain select b from t1 where c > 750; 447id select_type table type possible_keys key key_len ref rows Extra 4481 SIMPLE t1 range c c 4 NULL NULL; Using where 449select c from t1 where c > 750; 450c 451800 452900 453DROP TABLE t1; 454CREATE TABLE t1(a INT, b INT, c INT, d INT, PRIMARY KEY(a,b,c), CLUSTERING KEY(b), KEY (c)) ENGINE=TOKUDB 455PARTITION BY RANGE(c) (PARTITION p0 VALUES LESS THAN (500) ENGINE = TOKUDB, PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = TOKUDB); 456insert into t1 values (1,10,100,1000),(2,20,200,2000),(3,30,300,3000),(4,40,400,4000),(5,50,500,5000),(6,60,600,6000),(7,70,700,7000),(8,80,800,8000),(9,90,900,9000); 457explain select * from t1 where a > 5; 458id select_type table type possible_keys key key_len ref rows Extra 4591 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where 460select * from t1 where a > 5; 461a b c d 4626 60 600 6000 4637 70 700 7000 4648 80 800 8000 4659 90 900 9000 466explain select * from t1 where b > 30; 467id select_type table type possible_keys key key_len ref rows Extra 4681 SIMPLE t1 range b b 4 NULL NULL; Using where 469select * from t1 where b > 30; 470a b c d 4714 40 400 4000 4725 50 500 5000 4736 60 600 6000 4747 70 700 7000 4758 80 800 8000 4769 90 900 9000 477explain select * from t1 where c > 750; 478id select_type table type possible_keys key key_len ref rows Extra 4791 SIMPLE t1 range c c 4 NULL NULL; Using where 480select * from t1 where c > 750; 481a b c d 4828 80 800 8000 4839 90 900 9000 484explain select a from t1 where a > 8; 485id select_type table type possible_keys key key_len ref rows Extra 4861 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index 487select a from t1 where a > 8; 488a 4899 490explain select a,b from t1 where b > 30; 491id select_type table type possible_keys key key_len ref rows Extra 4921 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 493select a,b from t1 where b > 30; 494a b 4954 40 4965 50 4976 60 4987 70 4998 80 5009 90 501explain select a,b from t1 where c > 750; 502id select_type table type possible_keys key key_len ref rows Extra 5031 SIMPLE t1 index c b 4 NULL NULL; Using where; Using index 504select a,c from t1 where c > 750; 505a c 5068 800 5079 900 508alter table t1 add clustering index bdca(b,d,c,a); 509insert into t1 values (10,10,10,10); 510alter table t1 drop index bdca; 511alter table t1 drop primary key; 512explain select * from t1 where a > 5; 513id select_type table type possible_keys key key_len ref rows Extra 5141 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where 515select * from t1 where a > 5; 516a b c d 51710 10 10 10 5186 60 600 6000 5197 70 700 7000 5208 80 800 8000 5219 90 900 9000 522explain select * from t1 where b > 30; 523id select_type table type possible_keys key key_len ref rows Extra 5241 SIMPLE t1 range b b 4 NULL NULL; Using where 525select * from t1 where b > 30; 526a b c d 5274 40 400 4000 5285 50 500 5000 5296 60 600 6000 5307 70 700 7000 5318 80 800 8000 5329 90 900 9000 533explain select * from t1 where c > 750; 534id select_type table type possible_keys key key_len ref rows Extra 5351 SIMPLE t1 range c c 4 NULL NULL; Using where 536select * from t1 where c > 750; 537a b c d 5388 80 800 8000 5399 90 900 9000 540explain select b from t1 where b > 30; 541id select_type table type possible_keys key key_len ref rows Extra 5421 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 543select b from t1 where b > 30; 544b 54540 54650 54760 54870 54980 55090 551explain select b from t1 where c > 750; 552id select_type table type possible_keys key key_len ref rows Extra 5531 SIMPLE t1 range c c 4 NULL NULL; Using where 554select c from t1 where c > 750; 555c 556800 557900 558alter table t1 add e varchar(20); 559alter table t1 add primary key (a,b,c); 560explain select * from t1 where a > 5; 561id select_type table type possible_keys key key_len ref rows Extra 5621 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where 563select * from t1 where a > 5; 564a b c d e 56510 10 10 10 NULL 5666 60 600 6000 NULL 5677 70 700 7000 NULL 5688 80 800 8000 NULL 5699 90 900 9000 NULL 570explain select * from t1 where b > 30; 571id select_type table type possible_keys key key_len ref rows Extra 5721 SIMPLE t1 range b b 4 NULL NULL; Using where 573select * from t1 where b > 30; 574a b c d e 5754 40 400 4000 NULL 5765 50 500 5000 NULL 5776 60 600 6000 NULL 5787 70 700 7000 NULL 5798 80 800 8000 NULL 5809 90 900 9000 NULL 581explain select * from t1 where c > 750; 582id select_type table type possible_keys key key_len ref rows Extra 5831 SIMPLE t1 range c c 4 NULL NULL; Using where 584select * from t1 where c > 750; 585a b c d e 5868 80 800 8000 NULL 5879 90 900 9000 NULL 588explain select a from t1 where a > 8; 589id select_type table type possible_keys key key_len ref rows Extra 5901 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index 591select a from t1 where a > 8; 592a 59310 5949 595explain select a,b from t1 where b > 30; 596id select_type table type possible_keys key key_len ref rows Extra 5971 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 598select a,b from t1 where b > 30; 599a b 6004 40 6015 50 6026 60 6037 70 6048 80 6059 90 606explain select a,b from t1 where c > 750; 607id select_type table type possible_keys key key_len ref rows Extra 6081 SIMPLE t1 index c b 4 NULL NULL; Using where; Using index 609select a,c from t1 where c > 750; 610a c 6118 800 6129 900 613alter table t1 drop primary key; 614explain select * from t1 where a > 5; 615id select_type table type possible_keys key key_len ref rows Extra 6161 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where 617select * from t1 where a > 5; 618a b c d e 61910 10 10 10 NULL 6206 60 600 6000 NULL 6217 70 700 7000 NULL 6228 80 800 8000 NULL 6239 90 900 9000 NULL 624explain select * from t1 where b > 30; 625id select_type table type possible_keys key key_len ref rows Extra 6261 SIMPLE t1 range b b 4 NULL NULL; Using where 627select * from t1 where b > 30; 628a b c d e 6294 40 400 4000 NULL 6305 50 500 5000 NULL 6316 60 600 6000 NULL 6327 70 700 7000 NULL 6338 80 800 8000 NULL 6349 90 900 9000 NULL 635explain select * from t1 where c > 750; 636id select_type table type possible_keys key key_len ref rows Extra 6371 SIMPLE t1 range c c 4 NULL NULL; Using where 638select * from t1 where c > 750; 639a b c d e 6408 80 800 8000 NULL 6419 90 900 9000 NULL 642explain select b from t1 where b > 30; 643id select_type table type possible_keys key key_len ref rows Extra 6441 SIMPLE t1 range b b 4 NULL NULL; Using where; Using index 645select b from t1 where b > 30; 646b 64740 64850 64960 65070 65180 65290 653explain select b from t1 where c > 750; 654id select_type table type possible_keys key key_len ref rows Extra 6551 SIMPLE t1 range c c 4 NULL NULL; Using where 656select c from t1 where c > 750; 657c 658800 659900 660DROP TABLE t1; 661