-
as seen on SQL Authority
- Search for 'SQL Authority'
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times.
When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling…
>>> More
-
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times.When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Most Oracle Applications DBAs and E-Business Suite users understand the importance of accurate database statistics. Missing, stale or skewed statistics can adversely affect performance.
Oracle E-Business Suite statistics should only be gathered using FND_STATS or the Gather Statistics…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Incremental statistics maintenance was introduced in Oracle Database 11g to improve the performance of gathering statistics on large partitioned table. When incremental statistics maintenance is enabled for a partitioned table, oracle
accurately generated global level statistics by aggregating…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
There was huge interest in our OOW session last year on Managing Optimizer Statistics. It seems statistics and the maintenance of them continues to baffle people. In order to help dispel the mysteries surround statistics management we have created a two part white paper series on Optimizer statistics…
>>> More