Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database

© Darl Kuhn, Sam R. Alapati and Bill Padfield 2016

Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_9

9. SQL Tuning Advisor

Darl Kuhn¹ , Sam R. Alapati² and Bill Padfield³

(1)Morrison, Colorado, USA

(2)Flower Mound, Texas, USA

(3)Aurora, Colorado, USA

The SQL Tuning Advisor is a tool that analyzes one or more SQL statements and provides advice in the form of

• Creating indexes.

• 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 ...