ideas for tuning a strange query?

I have a strange query scenario.
Maybe someone would care to comment.

The query looks like

SELECT
   A Bunch of field
FROM
   SYSADM.SPECIFIC B
 , SYSADM.ARTICLE A
 WHERE
     RTRIM(B.ARTNO)||'*'||RTRIM(B.ARTICLENO)||'*'||RTRIM(B.DIMENSION) ||'*'||RTRIM(B.INTCOLOR)=A.ARTIKEY(+); There is a unique index on ARTIKEY.

any ideas for optimizing this query?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 30 2000 - 08:53:57 CST