A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2:
And you’ll find more information in our documentation and in posts by our optimizer folks:
- Database SQL Tuning Guide 12c:
Gathering Incremental Statistics on Partitioned Objects - Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table? (Mar 18, 2012)
https://blogs.oracle.com/optimizer/entry/incremental_statistics_maintenance_what_statistics
And you may read on this follow-up blog post about a related real world customer example …
Database Upgrade
Important to know is …
Continue reading...
