Using the index matching rules on a table with indexes created on columns C1,C2,C3,and C4,list the column(s)that would be matched if the WHERE clause contained the conditions "C2 = 10 AND C1 BETWEEN 15 AND 20 AND C3

Question

Using the index matching rules on a table with indexes created on columns C1,C2,C3,and C4,list the column(s)that would be matched if the WHERE clause contained the conditions "C2 = 10 AND C1 BETWEEN 15 AND 20 AND C3 <= 4"._____________

Quizplus · Accepted Answer

The Answer of Using the index matching rules on a table with indexes created on columns C1,C2,C3,and C4,list the column(s)that would be matched if the WHERE clause contained the conditions "C2 = 10 AND C1 BETWEEN 15 AND 20 AND C3 <= 4"._____________

Using the Index Matching Rules on a Table with Indexes