Database Tuning (MOSC)

MOSC Banner

Incremental stats on heavy partitioned table

edited Jul 27, 2019 5:01AM in Database Tuning (MOSC) 4 commentsAnswered

My client has huge table with partitioned table. They do not have control for any DML changes..  For example, they may update few hundred of records or some times they may delete millions of records per day. They see performance issues when they take stats and also re-indexing the indexes taking lot of time. Looks like the current stats update process is not for the changed records only. We would like to review the best practices for such huge partitioned table with daily / weekly re-indexing.

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