SQL - Indexes and Query Performance
Which SQL command correctly creates a B-tree index on the column
email of the table users?Which SQL command correctly creates a B-tree index on the column email of the table users?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall correct syntax for creating an index
The correct syntax is CREATE INDEX index_name ON table_name (column_name);Step 2: Match options to syntax
Only CREATE INDEX idx_email ON users (email); matches the correct syntax for creating a B-tree index.Final Answer:
CREATE INDEX idx_email ON users (email); -> Option BQuick Check:
Index creation syntax = CREATE INDEX [OK]
Quick Trick: Use CREATE INDEX to build B-tree indexes [OK]
Common Mistakes:
- Using CREATE TABLE instead of CREATE INDEX
- Trying to INSERT an index
- Using DROP instead of CREATE
Master "Indexes and Query Performance" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes