Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> rtrim() performance nightmare???

rtrim() performance nightmare???

From: InfoTech Consulting, Inc. <dmorse_at_iquest.net>
Date: Thu, 17 Sep 1998 16:26:27 -0500
Message-ID: <6truq7$mf5$1@news.iquest.net>


I was testing the performance of a query today and noticed the following query took a LONG TIME to run (when using rtrim() function):

SELECT field1, field2
FROM table_a
WHERE field3 = 'value' and
rtrim(field4) = 'value'

... this one returns data almost immediately: SELECT field1, field2
FROM table_a
WHERE field3 = 'value' and
field4 LIKE 'value%'

Is the rtrim() function a performance hog?

Thanks,

Dave Morse
Consultant - InfoTech Consulting, Inc.
mailto:dmorse_at_iquest.net Received on Thu Sep 17 1998 - 16:26:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US