Re: Using DBMS_STATS makes query execute WORSE.

From: Alek Lapuc <obimbus_at_poczta.onet.pl>
Date: 8 Oct 2004 02:11:21 -0700
Message-ID: <7d3c208.0410080111.7a0e852@posting.google.com>

Hi.

Thanks for all the anwsers. I think we shall try with adjusting optimizer parametrs, as it turned out that simmilar problem may exist in modules that we are currently deploying.

We shall try also compressing indexes.

Calculating full statistics instead of estimating did no better (obviously index with 25% selectivity is to bad for CBO any way).

Best regards,

Aleksander Lapuc

pratap_fin_at_rediffmail.com (Pratap) wrote in message news:<830861d2.0410052111.a08c33d_at_posting.google.com>...
> Why don't you gather ALL statistics of the table instead of estimating
> the statistics. Also you may compress the index by using.
>
> alter index idx_name rebuild compress 1;
>
> This will reduce the size of the index and optimizer may use it.
Received on Fri Oct 08 2004 - 04:11:21 CDT