Re: performance issue using SQL Plus
From: djuly <djuly_at_wanadoo.nl>
Date: 21 Feb 2002 06:11:22 -0600
Message-ID: <3c74e3ea$1_2_at_spamkiller.newsgroups.com>
Date: 21 Feb 2002 06:11:22 -0600
Message-ID: <3c74e3ea$1_2_at_spamkiller.newsgroups.com>
With LIKE upper('Smith%') you are using a function and like operator on the index. This means that although you intend to use the index you are supressing it due to the use of the function. You can use a function with the index with function indexes in oracle. Try first not to use the upper function first.
Paul Djuly
-- Ir. A.P. Djuly Gabon Straat 5 2622 Delft djuly_at_wanadoo.nl Ir. A.P. Djuly Gabon Straat 5 2622 Delft djuly_at_wanadoo.nl Posted via dBforums http://dbforums.comReceived on Thu Feb 21 2002 - 13:11:22 CET