If the SQL statement SELECT C1,C2,C3
FROM T4
WHERE C2 = 'Smith';
Is frequently executed,which column(s)should be considered for indexing based only on the statement itself?
A)C1 only
B)C2 only
C)C3 only
D)C1 and C2

Question

Quizplus · Accepted Answer

Based on the statement, the WHERE clause is checking for a value in the C2 column. Therefore, indexing should be considered on the C2 column to improve the query's performance. Indexing other columns (C1 or C3) may not improve performance in this case.

If the SQL Statement SELECT C1,C2,C3