Forum Stats

  • 3,824,874 Users
  • 2,260,435 Discussions


Missing Indexes

754320 Member Posts: 22
edited Apr 15, 2010 10:46AM in SQL & PL/SQL
Any idea if there is a tuning advisor (or any other tool) for Oracle DBAs which proposes the creation of an index to improve the performance of a particular query? Similar to the Microsoft SQL server Activity Monitor explain plan?



  • Hoek
    Hoek Member Posts: 16,087 Gold Crown
    edited Apr 15, 2010 10:46AM
    Yes, check the Oracle docs:

    Home of the Oracle docs:
  • Gaff
    Gaff Member Posts: 1,490
    Absolutely! Oracle Grid Control/Enterprise Manager. Run your query and you'll be able to see it in the OEM GUI and have OEM analyze the query (or set of queries) and suggest tuning advise. The link is called SQL Adviser I believe? (Don't have it in front of me at the moment.)

    You don't say what version you have, and OEM has slightly different looks depending on its version, but this should get you started.

    You can also do it through SQL, but I never do.
This discussion has been closed.