SQL Access Advisor
In this chapter, you’ll learn about the Oracle SQL Access Advisor, which is useful when you need to analyze how an object is being accessed and how to improve that access path to reduce the optimizer cost.
Oracle SQL Access Advisor, introduced in Oracle Database 10g, receives a real or hypothetical workload as input and then analyzes how each object involved in each SQL statement is being accessed. It uses Automatic Tuning Optimizer to perform the analysis of several hypothetical improvements and calculates the resulting optimizer cost of each improvement. It lists all improvements that offer considerable benefits ...