sql / beginner
Snippet
Accelerating Lookup Operations using CREATE INDEX
Creating an index on a frequently searched column builds a supporting data structure that reduces query lookup times from linear table scans to logarithmic searches.
snippet.sql
sql
1
CREATE INDEX idx_user_email ON users (email);
Breakdown
1
CREATE INDEX idx_user_email
Declares a new database index named idx_user_email.
2
ON users (email);
Attaches the index structure to the email column of the users table.