sql / beginner
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
1
2
CREATE INDEX idx_customer_emailON customers (email_address);
Breakdown
1
CREATE INDEX idx_customer_email
Declares a new database index named idx_customer_email.
2
ON customers (email_address);
Binds the index to the email_address column inside the customers table.