Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update/Select on CHAR Column Behaves Differently In Stored Procedure
you might find that
UPDATE ...
SET ...
WHERE TRIM(some_column) = TRIM(the_other_column);
performs slower than
UPDATE ...
SET ...
WHERE some_column = RPAD(the_other_column, some_column_length);
unless there is a function based index on TRIM(some_column) Received on Thu May 05 2005 - 14:39:22 CDT