Re: query optimization
From: Noah Wollowick <nwollowi_at_eecs.tufts.edu>
Date: Wed, 19 May 1999 18:40:31 -0400
Message-ID: <Pine.GSO.4.05.9905191839220.24007-100000_at_allegro>
Date: Wed, 19 May 1999 18:40:31 -0400
Message-ID: <Pine.GSO.4.05.9905191839220.24007-100000_at_allegro>
no, the query would still use any indexes on the title column.
the following would turn the index off:
select title, id from movies
where UPPER(title) = 'JFK';
Noah Wollowick
Microsoft/Oracle Consultant
noah_at_axisdevelopment.com
On Sat, 15 May 1999, wozi wrote:
> Hi all,
>
> Here is a sample query:
> SQL> select title, id from movies
> 2 where title =upper('jfk');
>
> TITLE ID
> ------------------------------ ----------
> JFK 231
>
> Does the use of the UPPER function causes oracle do a full
> table scan? Or does it slows down the retrieval of the record?
>
> thanks, wozi_at_dhc.net
>
>
>
>
Received on Thu May 20 1999 - 00:40:31 CEST