Managing Optimizer Statistics Paper

Over the past couple days I’ve been reading through the recent paper by Karen Morton entitled “Managing Statistics for Optimal Query Performance“. In this paper Karen goes over many of the topics I have discussed as well (and a few that I have not) in the following blog posts:

• Troubleshooting Bad Execution Plans
• There Is No Time Like ‘NOW%’ To Use Dynamic Sampling
• Choosing An Optimal Stats Gathering Strategy
• DBMS_STATS, METHOD_OPT and FOR ALL INDEXED COLUMNS

Overall I think Karen does a good job discussing the key issues related to object statistics and has examples to assist in understanding where and why issues can arise. I’m also a fan of works that do not project an answer, but rather provide information, how to use that information, use working examples, and ultimately leaves the reader with the task of how to best apply the new found knowledge to their environment. I would recommend to all to give it a read.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22920863/viewspace-660792/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22920863/viewspace-660792/