Re: Freezing database statistics

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Sun, 22 Oct 2006 16:28:49 GMT
Message-Id: <pan.2006.10.22.16.28.50.460880@verizon.net>

On Sun, 22 Oct 2006 17:15:56 +0200, Robert Klemme wrote:

> Plans do not only depend on statistics but also other factors
> (conditions in the WHERE clause for example). So freezing stats IMHO
> does not guarantee the same execution plan for every execution of a
> piece of SQL.

My idea of how CBO works is that if both statistics and SQL are the same, then the execution plan will be the same. So, if the statistics is frozen, the same SQL should execute using the same plan. Do you have any contradicting information?

-- 
http://www.mladen-gogala.com

Received on Sun Oct 22 2006 - 11:28:49 CDT