Database Tuning (MOSC)

MOSC Banner

Indexes not being analyzed for optimizer statistics

edited Nov 30, 2011 5:19AM in Database Tuning (MOSC) 2 commentsAnswered
I have an issue in my database where my tables are being analyzed each night and those that have a change of 10% or greater are getting their statistics updated.  What I am not seeing is the indexes being analyzed.  One set of indexes for a table, that was last analyzed on Nov 4, shows the indexes were last analyzed on Oct 11. The statistics show that they are stale but still not getting analyzed.  Is there a setting or something to make sure the indexes get analyzed?  I thought the auto optimizer would also update the index statistics.

Any help is greatly appreciated, I've tried google and oracle documentation but I have not found an answer.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center