Freezing database statistics

Freezing database statistics

I am on Oracle 10.1.0.4 on Windows 2000 server. I have found that when database statistics is computed, some times plans change so much that time of some queries changes from a few second to hours, so I have collected statistics to produce good plan and froze the statistics (lock the statistics). I am assuming that freezing statistics will also freeze the plans, i.e., same plan will be used irrespective of how much data is modified in the underlying tables. Thus, there will not be any surprises.

If in future some queries are found to be slow, I will revisit database statistics collection, but for now statistics is frozen. Is above a good strategy, Being a production system, I cannot cope with variation in plans especially when they become worse and users start screaming. Received on Sun Oct 22 2006 - 09:16:59 CDT