Snippet

Speeding Up Search Operations with CREATE INDEX

Creating an index on a frequently queried column enables the database engine to locate records efficiently without scanning the entire table.

snippet.sql

sql

CREATE INDEX idx_customer_email
ON customers (email_address);

Breakdown

CREATE INDEX idx_customer_email

Declares a new database index named idx_customer_email.

ON customers (email_address);

Binds the index to the email_address column inside the customers table.