Advertisement
Guest User

Untitled

a guest
Jan 18th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.19 KB | None | 0 0
  1. EXPLAIN SELECT * FROM READERS WHERE FIRSTNAME = "John";
  2.  
  3. CREATE INDEX FIRSTN ON READERS (FIRSTNAME);
  4. CREATE INDEX BOOKT ON BOOKS (TITLE);
  5.  
  6. EXPLAIN SELECT * FROM READERS WHERE FIRSTNAME = "John";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement