Using indexes

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?

Thx to all. Received on Thu Aug 24 2006 - 03:25:54 CDT