Re: Using indexes

On 2006-08-24, devjnr_at_gmail.com <devjnr_at_gmail.com> wrote:
> I have sql server backgrounds and I remember that (in a case
> insensitive environment) a query like this:
>
> where car = 'red' also select value like 'RED' or 'Red'
>
> In Oracle I'm seeing that it doesn't work this way.
>
> It can be simple to do something like this:
>
> where lower(car) = 'red'
>
> but I remember that this way in sql server indexes are not used, so a
> table scan is performed.
>
> What is the actual behavior of Oracle?

It is possible in 10g and I have written about it at   http://www.adp-gmbh.ch/blog/2005/june/24.html

hth,
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/