mysql分页语句where id > 0 能提高效率

mysql> explain SELECT * FROM email_group_1 where email_gp_id > 0
 ORDER BY email_gp_id ASC LIMIT 200000 , 100;
+----+-------------+---------------+-------+---------------------+---------+---------+------+--------+-------------+
| id | select_type | table         | type  | possible_keys       | key     | key_len | ref  | rows   | Extra       |
+----+-------------+---------------+-------+---------------------+---------+---------+------+--------+-------------+
|  1 | SIMPLE      | email_group_1 | range | PRIMARY,email_gp_id | PRIMARY | 4       | NULL | 246179 | Using where |
+----+-------------+---------------+-------+---------------------+---------+---------+------+--------+-------------+
1 row in set
mysql> explain SELECT * FROM email_group_1
 ORDER BY email_gp_id ASC LIMIT 200000 , 100;
+----+-------------+---------------+------+---------------+------+---------+------+--------+----------------+
| id | select_type | table         | type | possible_keys | key  | key_len | ref  | rows   | Extra          |
+----+-------------+---------------+------+---------------+------+---------+------+--------+----------------+
|  1 | SIMPLE      | email_group_1 | ALL  | NULL          | NULL | NULL    | NULL | 246348 | Using filesort |
+----+-------------+---------------+------+---------------+------+---------+------+--------+----------------+
1 row in set
mysql> 

 

能让查询从10多秒变成1秒左右,但是尾页时会有点慢.