query optimization

From: wozi <wozi_at_dhc.net>
Date: Sat, 15 May 1999 11:26:27 -0700
Message-ID: <A3A3D19D8A15151C.0E94A48C48F6AECA.A6CEBF67DB23A92E_at_library-proxy.airnews.net>



Hi all,

Here is a sample query:
SQL> select title, id from movies
[Quoted]   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 Sat May 15 1999 - 20:26:27 CEST

Original text of this message