[Solved] Consider this SQL statement to create an index:CREATE INDEX idx_price ON products price;What is wrong with this statement? | SQL

SQL - Indexes and Query Performance

Consider this SQL statement to create an index:

CREATE INDEX idx_price ON products price;

What is wrong with this statement?

ATable name should come after the column name

BIndex name cannot start with 'idx_'

CMissing parentheses around the column name

DCREATE INDEX cannot be used on numeric columns

Step-by-Step Solution

Solution:

Step 1: Check the syntax for CREATE INDEX
The column name must be inside parentheses after the table name.
Step 2: Identify the syntax error
The statement is missing parentheses around price. It should be ON products(price).
Final Answer:
Missing parentheses around the column name -> Option C
Quick Check:
Column name needs parentheses = C [OK]

Quick Trick: Column name must be in parentheses after table [OK]

Common Mistakes:

Master "Indexes and Query Performance" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider this SQL statement to create an index: