Skip to content

Instantly share code, notes, and snippets.

@simonrenoult

simonrenoult/use_primary.sql

Created July 1, 2019 09:01
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 simonrenoult/fb344290f6f307452a5f3a8f53060a11 to your computer and use it in GitHub Desktop.
Save simonrenoult/fb344290f6f307452a5f3a8f53060a11 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
use_primary.sql
mysql> SELECT SQL_NO_CACHE * FROM articles USE INDEX(PRIMARY) WHERE article_id = 150000;
+------------+---------------+-----------------+
| article_id | article_title | article_content |
+------------+---------------+-----------------+
| 150000 | Title 150000 | Content 150000 |
+------------+---------------+-----------------+
1 row in set (0.62 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment