A while back I blogged already about Incremental Statistics collection in Oracle Database 220.127.116.11:
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)
And you may read on this follow-up blog post about a related real world customer example …
Important to know is …Continue reading...