Hi, Tim
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(+);
I guess that query won't return the result quickly if the table SPECIFIC has quite a many rows. If SPECIFIC table is not a master table that hardly grow,there seems to be a design problem. The SPECIFIC table can't avoid full table access with current structure. It can't use indexes.
If it is not too late, the best remedy is to consider the normalization again.
HTH.
OCP8 DBA