Re: When stats trash your performance

On 07/12/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> A problem I've run into before is people running the old ANALYZE statements without specifying a sample size. This will default to a sample size of only 1064 rows (regardless of tables size)!
>
>
>
>

That could be it, thanks. Most of the core tables are pretty large (in the hundreds of thousands of rows) so 1064 rows would be a tiny sample, less than 1%.

I'll try to get them to let me reanalyze the tables with a decent sample size, 5 or 10%.

Stephen

--
It's better to ask a silly question than to make a silly assumption.

http://stephensorablog.blogspot.com/
--
http://www.freelists.org/webpage/oracle-l