which one would you use an index fast full scan to impr…

For which one would you use an index fast full scan to improve performance?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


prabhu

prabhu

B – Index Fast Full Scan Usage To Avoid Full Table Scans (Doc ID 70135.1)