For which one would you use an index fast full scan to improve performance?
A.
a query having all the columns of an index in the where clause
B.
a query that does not need to access table rows
C.
a query that needs to access table rows along with an index
D.
a column in an index that is compressed
A
B – Index Fast Full Scan Usage To Avoid Full Table Scans (Doc ID 70135.1)