Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> rtrim() performance nightmare???
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