O'Reilly logo

Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database by Bill Padfield, Sam R Alapati, Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required