# Index

SELECT * FROM EMPLOYEE;
EXPLAIN SELECT * FROM EMPLOYEE WHERE DOB='1992-06-22';

CREATE INDEX myindex ON employee(dob);

EXPLAIN SELECT * FROM EMPLOYEE WHERE DOB='1992-06-22';

DROP INDEX myindex ON employee;

SHOW INDEXES FROM EMPLOYEE;