Re: Use of Oracle indexes

[Arjan Hoornstra <ahoor@YAHOO.COM>]

Well, I don't know much of Oracle but my exprience with forced indexes
is: don't. Usually the optimizer is right in not choosing an index. And
if you think you know better, first try to update your index
statistics, then look at the query to see if there is a statement you
forgot or if you use functions or or's.
I'm not trying to be a wise-guy but just talking from experience. Then,
again, I don't know how Oracle responds to this...

Arjan



--- "Turner, Ivan" <Ivan.Turner@QWEST.COM> wrote:
> Begin-Select
> /*+ INDEX(IA PSEITEM_ACTIVITY) */
> IA.CUST_ID
> IA.ITEM
> IA.ENTRY_AMT
>
> Will the above SQR code utilize the index or the code below utilize
> the
> index?
>
> Begin-Select  /*+ INDEX(IA PSEITEM_ACTIVITY) */
> IA.CUST_ID
> IA.ITEM
> IA.ENTRY_AMT


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/