The SQL Tuning Advisor is a tool that analyzes one or more SQL statements and provides advice in the form of
Creating SQL profiles.
Establishing plan baselines.
Generating fresh statistics.
Restructuring a query
To fully understand how the SQL Tuning Advisor tool works, we need to lay some groundwork and explain a few terms. Firstly, the Oracle query optimizer operates in two different modes: normal and tuning. When a SQL statement ...