Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to speed analyzing histograms
AnySQL (d.c.b.a) wrote:
> You should increase the sort_area_size(100M) and
> db_file_multiblock_read_count (128), for big table, please estimate
> statistics, for the table which did not change too much, do not need to
> analyze them too often.
>
> Welcome, AnySQL
> http://www.anysql.net/en/
I would consider the chances of this helping anything as being quite low.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Nov 09 2005 - 10:03:54 CST
![]() |
![]() |