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,
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