Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using DBMS_STATS makes query execute WORSE.

Re: Using DBMS_STATS makes query execute WORSE.

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 5 Oct 2004 22:11:51 -0700
Message-ID: <830861d2.0410052111.a08c33d@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 Wed Oct 06 2004 - 00:11:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US