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: optimize this!

Re: optimize this!

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 3 Oct 2004 21:39:12 -0700
Message-ID: <830861d2.0410032039.2c62e18c@posting.google.com> 





alter index BILLS_IDX2 compress 2;



I am assuming here that BILLS_IDX2 is not a unique index. This may
make your query a bit faster.



Regards,



Pratap
Received on Sun Oct 03 2004 - 23:39:12 CDT












Original text of this message













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