Auto optimize vs oracle tuning advisor

Toad for Oracle
1

What is the difference between auto optimize and oracle tuning advisor?

2

Auto-optimize uses a Quest Product, SQL Optimizer.
Oracle Tuning Advisor uses an Oracle product built into the database called SQL Tuning Advisor.

SQL Optimizer might suggest a rewrite or an optimizer hint or add and index.

Oracle Tuning Advisor creates a "profile" (a script) that you can run/install so that Oracle can run your SQL better without changing it. I don't remember offhand if it offers to create an index, but it may.

3

How do you get it to tell you which indexes to add? Probably need an index.

4

Auto-optimize just does rewrites and optimizer hints (sorry I misspoke about an index here) but if you want to explore index possibilities, click here:

image
image711×353 18 KB

Oracle Tuning Advisor will give its results (which may or may not include in index) here:

image
image1118×810 66.3 KB