Re: Freezing database statistics

Niall Litchfield schreef:

[..]
>
> Oracle won't (or rather if it does its a bug) get the wrong result,
> however it may decide upon a pretty bad execution plan because it
> doesn't know what the spread of the data is.
>

If it _does_ get the wrong result, this would be a nice, modern version of the 30 year old "Database Halloween Problem".

http://blogs.ittoolbox.com/database/technology/archives/what-is-the-halloween-problem-in-databases-12618

-- 
Jeroen