[DB-SIG] Parameters in DCOracle2

Jekabs Andrushaitis jekabs.andrusaitis@tietoenator.com
Thu, 22 Aug 2002 15:28:16 +0200


> I expect this to break index usage, I suppose...
Yes, under Oracle 7.x  this does break index usage, however
Oracle states that in 8.x and 9.x query execution has been improved
and LTRIM and RTRIM in most cases does not break index usage
any more.
But still storing data in one style (with trailing spaces) and then
trying to look it up by another style (without spaces) sounds a bad
practice to me...

Jekabs Andrushaitis
Senior system analyst
TietoEnator Financial Solutions
41 Lacplesa Str.
Riga, LV-1011, Latvia
Tel: +371 7286660
Fax: +371 7243000
E-mail: jekabs.andrusaitis@tietoenator.com