Skip to content

Instantly share code, notes, and snippets.

@toddsampson

toddsampson/EstimateNumberOfRows.sql

Last active December 28, 2015 06:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save toddsampson/7456649 to your computer and use it in GitHub Desktop.
Save toddsampson/7456649 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
NumberOfRows.sql
select count(*) from messages;
Raw
QueryIndices.sql
mysql> select count(*) from messages use index (index_messages_on_remote_created_at);
+----------+
| count(*) |
+----------+
| 1276831 |
+----------+
1 row in set (3.19 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment