Cacher is the code snippet organizer for pro developers

CREATE INDEX 'NAME1' ON READERS (LASTNAME, FIRSTNAME);
CREATE INDEX 'NAME2' ON READERS (FIRSTNAME, LASTNAME);
CREATE INDEX TITLE ON BOOKS (TITLE);
EXPLAIN SELECT * FROM READERS WHERE FIRSTNAME = "John";