t-janicki
1/28/2019 - 9:05 PM

KODILLA 22.6 INDEX.sql

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";