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: performance tuning question

Re: performance tuning question

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Fri, 3 May 2002 09:51:00 +0200
Message-ID: <aatfgl$7l6$1@news.mch.sbs.de> 





Vladimir,



the index on id is a must in your case. It should give you more than 20% on
a table with several 1000 rows.



Did you analyze your table while it was empty or contained only very few
rows? This may make the optimizer believe that a full scan is cheaper than
the index access.



Regards


Stephan
Received on Fri May 03 2002 - 02:51:00 CDT












Original text of this message













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