Q). Assume we have a table that describes subject details taught at gateforum
Class(SubjName,FacultyName,AvgRating,remarks)
There are three indexes on this table:
I1: Clustered B+tree on <FacultyName,remarks>
I2: Unclustered hash table on <SubjName>
I3: Unclustered B+tree on <AvgRating>
For the following Query which index is the best to use?
Select * from
Class
Where AvgRating $\leq$ 5 AND AvgRating $\geq$ 4 AND FacultyName ="Raju"
(A) I1
(B) l2
(C) l3
(D) All indices l1,l2,l3 will be equally efficient for the given query