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