Re: query optimization
Date: Sun, 16 May 1999 21:12:41 GMT
Message-ID: <7hncc8$838$1_at_nnrp1.deja.com>
Before 8.1 every function in the where clause caused a full table scan.
In you case it would.
In 8.1 you have the possibility to use
a functionbased index which would
allow the optimizer to use the index.
Regards
Dante
In article <A3A3D19D8A15151C.0E94A48C48F6AECA.A6CEBF67DB23A92E_at_libraryproxy.
airnews.net>,
"wozi" <wozi_at_dhc.net> 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
>
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Sun May 16 1999 - 23:12:41 CEST