© 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. Alapati2 and Bill Padfield3

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

Get Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.