mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 5.0.67    |
+-----------+
1 row in set (0.04 sec)

mysql> SELECT SQL_NO_CACHE * FROM t1;
+----+------------+
| ID | Population |
+----+------------+
|  1 |          1 |
|  2 |          1 |
|  3 |          1 |
|  4 |          1 |
|  5 |          1 |
|  6 |          1 |
|  7 |          1 |
|  8 |          1 |
|  9 |          1 |
| 10 |          1 |
+----+------------+
10 rows in set (0.00 sec)

mysql> SELECT SQL_NO_CACHE * FROM t2;
+----+------------+
| ID | Population |
+----+------------+
|  1 |          2 |
|  2 |          2 |
|  3 |          2 |
|  4 |          2 |
|  5 |          2 |
|  6 |          2 |
|  7 |          2 |
|  8 |          2 |
|  9 |          2 |
| 10 |          2 |
+----+------------+
10 rows in set (0.00 sec)

mysql> SELECT SQL_NO_CACHE * FROM t0;
+----+------------+
| ID | Population |
+----+------------+
|  1 |          1 |
|  2 |          1 |
|  3 |          1 |
|  4 |          1 |
|  5 |          1 |
|  6 |          1 |
|  7 |          1 |
|  8 |          1 |
|  9 |          1 |
| 10 |          1 |
|  1 |          2 |
|  2 |          2 |
|  3 |          2 |
|  4 |          2 |
|  5 |          2 |
|  6 |          2 |
|  7 |          2 |
|  8 |          2 |
|  9 |          2 |
| 10 |          2 |
+----+------------+
20 rows in set (0.00 sec)

mysql> ALTER TABLE `t1` DISABLE KEYS;
Query OK, 0 rows affected (0.10 sec)

mysql> TRUNCATE TABLE `t1`;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO `t1` VALUES(1,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(2,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(3,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(4,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(5,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(6,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(7,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(8,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(9,1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `t1` VALUES(10,1);
Query OK, 1 row affected (0.00 sec)

mysql> ALTER TABLE `t1` ENABLE KEYS;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT SQL_NO_CACHE * FROM t0;
+----+------------+
| ID | Population |
+----+------------+
|  1 |          1 |
|  2 |          1 |
|  3 |          1 |
|  4 |          1 |
|  5 |          1 |
|  6 |          1 |
|  7 |          1 |
|  8 |          1 |
|  9 |          1 |
| 10 |          1 |
|  1 |          2 |
|  2 |          2 |
|  3 |          2 |
|  4 |          2 |
|  5 |          2 |
|  6 |          2 |
|  7 |          2 |
|  8 |          2 |
|  9 |          2 |
| 10 |          2 |
+----+------------+
20 rows in set (0.01 sec)