Re: How do you un-analyze tables?

On Thu, 28 Jun 2001 15:21:01 +0100, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>1. analyse <object> delete statistics;
>
>2. There are many many reasons why CBO might make the wrong decisions. these
>include , but are not limited to
>
>a) too small or unrepresentative a sample,
>b) skewed data distributions,
>c) poorly chosen init.ora parameters (for example db_multi_block_read_count)
>d) poor indexing of the data.

Don't forget that letting the statistics go stale also does that.

Brian Received on Thu Jun 28 2001 - 11:15:56 CDT