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?