Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "ak_tiredofspam@yahoo.com" <ak_tiredofspam@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Update/Select on CHAR Column Behaves Differently In Stored Procedure
Date: 5 May 2005 12:39:22 -0700
Organization: http://groups.google.com
Lines: 14
Message-ID: <1115321962.089383.138870@g14g2000cwa.googlegroups.com>
References: <1115303967.585241.275350@f14g2000cwb.googlegroups.com>
   <96kk71dud61gpdui3g0r3dsbb64n7l2mc9@4ax.com>
   <1115314726.991159.214430@f14g2000cwb.googlegroups.com>
   <lunk71d8koo3i4f24kk3nfnnv0i1r8qiil@4ax.com>
   <1115318126.856705.260820@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 205.156.188.254
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1115321966 31427 127.0.0.1 (5 May 2005 19:39:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 May 2005 19:39:26 +0000 (UTC)
In-Reply-To: <1115318126.856705.260820@g14g2000cwa.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=205.156.188.254;
   posting-account=GxvDVQwAAACIzoQWbx3Wrb_b4uAQN9nX
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242106

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)