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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index access vs Ignored hints

Re: Index access vs Ignored hints

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 15 Feb 2005 12:04:51 -0800
Message-ID: <1108497891.369010.63200@g14g2000cwa.googlegroups.com> 





But in some cases, the performance would sufer, since it would need to
retreive all rows with col_status='D', figure out which are the lowest
100, pass these, and start over.  If I could relly on the index being
used, then the first 100 rows read would always be the lowest ID, and
unneccessary block read would be avoided.
Is the performance hit the price to pay to guaranty consistent
execution path?
Received on Tue Feb 15 2005 - 14:04:51 CST












Original text of this message













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