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.

Run a query to see results

SQL Boy