Thank you! I completely missed that in the documentation. That
explains why I can't get it to use the index even with a hint. What an
annoying, and seemingly unnecessary restriction.
-Original Message-
Sent: Friday, February 15, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L
Oracle function based indexes do not work if OR clause is used .This is mentioned in
the oracle docs.
I think if u use union clause it may work out .
try and see...
> --- "Seefelt, Beth" <[EMAIL PROTECTED]>
> wrote: >
> > Hi everybody,
> >
> > I'm hoping someone can help me understand this
Can also try UNION.
Connor McDonald wrote:
>
> Add a hint to force it to use the index, and then
> check the costs - this may assist in telling you why
> the index was not chosen.
>
> Also, maybe see what happens using IN instead of OR
>
> hth
> connor
>
> --- "Seefelt, Beth" <[EMAIL PROTECT
Add a hint to force it to use the index, and then
check the costs - this may assist in telling you why
the index was not chosen.
Also, maybe see what happens using IN instead of OR
hth
connor
--- "Seefelt, Beth" <[EMAIL PROTECTED]>
wrote: >
> Hi everybody,
>
> I'm hoping someone can help me
Hi everybody,
I'm hoping someone can help me understand this.
I have this query -
SELECT ORDERID FROM WWW_SHOPCART
WHERE UPPER(MEMBERNAME) ='19891' ;
I added an index on the column UPPER(MEMBERNAME) and it works great.
I have another query -
SELECT ORDERID FROM WWW_SHOPCART
WHERE UPPE