Performance select statement

SELECT * FROM CATSPS INTO TABLE TCATSPS

WHERE TRANSFER = 'X' .

SELECT RUECK

STOKZ

CATSBELNR

FROM AFRU

INTO table T_AFRU

for all entries in tcatsps

WHERE CATSBELNR = TCATSPS-BELNR

AND STOKZ = TCATSPS-STOKZ.

In the above statement, Tcatsps internal table is getting around 3 Lakh records. Becos of which when i run the second select statement, time is taken for ever.

Can I improve the performance statment of 2nd select statemtn in any other effective way.

Thanks

Regds

Venu