Complete CREATE INDEX
Fill in the Blank Medium
Question
Fill in the blank to create an index on the email column:
Code
___ INDEX idx_email ON users(email);
Hint
This DDL command creates database objects.
Explanation
CREATE INDEX creates a new index on the specified column. The index speeds up queries that filter or sort by that column, at the cost of slower writes and extra storage.
Related Resources
Related Lessons
- Indexes
Learn CREATE INDEX.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.