Re: When stats trash your performance
- From: stephen booth <stephenbooth.uk@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Wed, 7 Dec 2005 22:03:40 +0000
On 07/12/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts: