Unnamed

EXPLAIN SELECT `faads_record`.`data_commons_id`, `faads_record`.`recipient_congressional_district` FROM `faads_record` ORDER BY `faads_record`.`data_commons_id` ASC LIMIT 1000 OFFSET 2395000;
+----+-------------+--------------+------+---------------+------+---------+------+----------+----------------+
| id | select_type | table        | type | possible_keys | key  | key_len | ref  | rows     | Extra          |
+----+-------------+--------------+------+---------------+------+---------+------+----------+----------------+
|  1 | SIMPLE      | faads_record | ALL  | NULL          | NULL | NULL    | NULL | 16008463 | Using filesort |
+----+-------------+--------------+------+---------------+------+---------+------+----------+----------------+


EXPLAIN SELECT `faads_record`.`data_commons_id`, `faads_record`.`recipient_congressional_district` FROM `faads_record` FORCE KEY (PRIMARY) ORDER BY `faads_record`.`data_commons_id` ASC LIMIT 1000 OFFSET 2395000;
+----+-------------+--------------+-------+---------------+---------+---------+------+---------+-------+
| id | select_type | table        | type  | possible_keys | key     | key_len | ref  | rows    | Extra |
+----+-------------+--------------+-------+---------------+---------+---------+------+---------+-------+
|  1 | SIMPLE      | faads_record | index | NULL          | PRIMARY | 4       | NULL | 2396000 |       |
+----+-------------+--------------+-------+---------------+---------+---------+------+---------+-------+