Performance of SELECT statement

Hello All,

The following statements are consuming huge time in my system. Could you please give me your inputs on tuning these queries

SELECT atinn FROM cabn INTO r_atinn-low

WHERE atkla = lc_chargrp_dim

AND anzst LE 8.

APPEND r_atinn.

ENDSELECT.

SELECT * FROM cabn INTO TABLE ij_cabn

FOR ALL ENTRIES IN r_atinn

WHERE atinn = r_atinn-low

ORDER BY PRIMARY KEY.

SELECT * FROM cabnt INTO TABLE ij_cabnt

FOR ALL ENTRIES IN r_atinn

WHERE atinn = r_atinn-low

ORDER BY PRIMARY KEY.

Thanks in advance

Sudha