Which SQL statement correctly creates an index on the column email in the table users?

easy📝 Syntax Q12 of 15

SQL - Indexes and Query Performance

Which SQL statement correctly creates an index on the column email in the table users?

ACREATE INDEX idx_email ON users(email);

BCREATE users INDEX ON email;

CINDEX CREATE ON users(email);

DCREATE INDEX users_email email;

Step-by-Step Solution

Solution:

Step 1: Recall correct CREATE INDEX syntax
The correct syntax is: CREATE INDEX index_name ON table_name(column_name);
Step 2: Match the options to syntax
CREATE INDEX idx_email ON users(email); matches the correct syntax exactly.
Final Answer:
CREATE INDEX idx_email ON users(email); -> Option A
Quick Check:
Correct CREATE INDEX syntax = CREATE INDEX idx_email ON users(email); [OK]

Quick Trick: CREATE INDEX index_name ON table(column) is correct syntax [OK]

Common Mistakes:

Master "Indexes and Query Performance" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes