11g Pending and Published Statistics
- Posted by Gavin Soorma
- On September 18, 2009
- 0 Comments
Prior to Oracle 11g, the default behaviour was to make statistics available for the optimizer to use as soon as they were gathered. While statistics are required to enable the optimizer to generate optimal execution plans, sometimes just by gathering fresh statistics tried and trusted execution plans can abruptly change and thereby adversely affect application […]
Read More