Which of the following is the correct syntax to create an index on the column 'email' in the 'users' table?

easy📝 Syntax Q3 of 15

PostgreSQL - Performance Tuning

ACREATE TABLE idx_email ON users(email);

BCREATE INDEX idx_email ON users(email);

CCREATE INDEX email_idx users(email);

DINDEX CREATE idx_email ON users(email);

Step-by-Step Solution

Solution:

Step 1: Recall the syntax for creating an index
The correct syntax is CREATE INDEX index_name ON table_name(column_name);
Step 2: Match syntax with options
CREATE INDEX idx_email ON users(email); matches the correct syntax exactly.
Final Answer:
CREATE INDEX idx_email ON users(email); -> Option B
Quick Check:
Index creation syntax = CREATE INDEX idx_email ON users(email); [OK]

Quick Trick: Use CREATE INDEX index_name ON table(column) [OK]

Common Mistakes:

Master "Performance Tuning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free