Database Indexing
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table.
Without an index, the database must scan the entire table (Full Table Scan) to find relevant rows.
CREATE INDEX idx_lastname ON users (lastname);
Task:
Create an index named idx_email on the email column of the users table.