Oracle
1Z0-417 · Question #31
For which one would you use an index fast full scan to improve performance?
The correct answer is A. a query having all the columns of an index in the where clause. 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.
Database Management and Configuration
Question
For which one would you use an index fast full scan to improve performance?
Options
- Aa query having all the columns of an index in the where clause
- Ba query that does not need to access table rows
- Ca query that needs to access table rows along with an index
- Da column in an index that is compressed
How the community answered
(22 responses)- A73% (16)
- B9% (2)
- C5% (1)
- D14% (3)
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.
Topics
#index fast full scan#query optimization#database performance#SQL tuning
Community Discussion
No community discussion yet for this question.