1Z0-117 · Question #24
Examine the Exhibit and view the structure of an indexes for the EMPLOYEES table. Which two actions might improve the performance of the query?
The correct answer is A. Use the ALL_ROWS hint in the query. E. Set the OPTIMIZER_MODE parameter to ALL_ROWS. A: The ALL_ROWS hint instructs the optimizer to optimize a statement block with a goal of best throughput, which is minimum total resource consumption. E: optimizer_mode=all_rows - This optimizer mode favors full-table scans (especially parallel full- table-scans) in cases…
Question
Examine the Exhibit and view the structure of an indexes for the EMPLOYEES table. Which two actions might improve the performance of the query?
Exhibits
Options
- AUse the ALL_ROWS hint in the query.
- BCollect the histogram statistics for the EMPLOYEE_ID column.
- CDecrease the value for the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter.
- DDecrease the index on the EMPLOYEE_ID if not being used.
- ESet the OPTIMIZER_MODE parameter to ALL_ROWS.
How the community answered
(23 responses)- A83% (19)
- B4% (1)
- C9% (2)
- D4% (1)
Explanation
A: The ALL_ROWS hint instructs the optimizer to optimize a statement block with a goal of best throughput, which is minimum total resource consumption. E: optimizer_mode=all_rows - This optimizer mode favors full-table scans (especially parallel full- table-scans) in cases where the server resources will be minimized. The all_rows mode is generally used during batch-oriented processing and for data warehouses where the goal is to minimize server resource consumption.
Topics
Community Discussion
No community discussion yet for this question.