Re: Using indexes

On 24.08.2006 10:25, 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?

You can easily check your execution plan. :-) After that you probably want to read this:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref928

Kind regards

        robert Received on Thu Aug 24 2006 - 03:49:00 CDT