Advertisement
Guest User

MYSQL Index

a guest
Mar 25th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. EXPLAIN SELECT *
  2. FROM READERS
  3. WHERE FIRSTNAME = 'John';
  4.  
  5. CREATE INDEX READERNAME ON READERS (FIRSTNAME);
  6.  
  7. CREATE INDEX BOOKTITLE ON BOOKS (TITLE);
  8.  
  9. EXPLAIN SELECT *
  10. FROM READERS
  11. WHERE FIRSTNAME = 'John';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement