Prev Question
Next Question

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

Explanation:
All of the columns required by SQL must reside in the index tree; that is, all columns in the SELECT and
WHERE clauses must exist in the index.
Reference: http://www.dba-oracle.com/t_index_fast_full_scan.htm

Prev Question
Next Question

Leave a Reply

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