Home » Oracle » 1z0-117 » Which two actions might improve the performance of the query?
Examine the Exhibit and view the structure of an indexes for the EMPLOYEES table.
Which two actions might improve the performance of the query?
Exhibit:
A. Use the ALL_ROWS hint in the query.
B. Collect the histogram statistics for the EMPLOYEE_ID column.
C. Decrease the value for the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter.
D. Decrease the index on the EMPLOYEE_ID if not being used.
E. Set the OPTIMIZER_MODE parameter to ALL_ROWS.
Correct Answer: AE
Explanation/Reference:
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.
Download Printable PDF. VALID exam to help you PASS.
|
|