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: Adding Indexes drastically slows down App

Re: Adding Indexes drastically slows down App

From: giorgio.sorbara _at_ sorcius.com <_at_>
Date: Wed, 20 Jun 2001 17:58:52 +0200
Message-ID: <9gqh8a$g71$1@news.mclink.it> 






It seems that Oracle use a different execution plan when you create the two
'evil' indexes.


Try to figure out yourself tracing the session or explaining the query... w/
and w/o the indexes.


If you got two different results... you may need to use HINTS and force
Oracle to use the


best performing query.


I would start thinking also whether the indexes are really needed by the
application... :)


HTH

Received on Wed Jun 20 2001 - 10:58:52 CDT












Original text of this message













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