Performance issue

Hi,

I have performance problen following code.It take more than 25 min to retrive data.Can help me to resolve it.

SELECT refbn rfbos rftyp gjahr wrttp stats twear yyaufnr hkont

lifnr SUM ( trbtr ) SUM ( fkbtr )

FROM fmioi INTO TABLE gt_fmioi

WHERE rldnr = gc_rldnr and

gjahr = pa_fyear and

fistl IN so_fctr and

fonds IN so_fund and

fipex IN so_comm and

fares = ' ' and

measure IN so_fprog and

wrttp IN (gc_wrttp_51,gc_wrttp_65) and

stats = gc_ststs and

fikrs = pa_area

GROUP BY refbn rfpos rftyp gjahr farea wrttp

stats twear yyaufnr hkont fikrs lifnr.

*I have maintain INDEX for follwing fields.*

rldnr = gc_rldnr value = '9A'

gjahr = pa_fyear value = 2007

fistl IN so_fctr and

fonds IN so_fund and

fipex IN so_comm and

fares = ' ' and

measure IN so_fprog and

wrttp IN (gc_wrttp_51,gc_wrttp_65) value = 51,65

stats = gc_ststs and

fikrs = pa_area value = 1000

Same thing happen for following code it take more than 25 min.

SELECT trbtr fkbtr wrttp hkont vogjahr voblnr kngjahr knbelnr knbuzei vrefbn vrfpo vrftyp FROM fmifiit

INTO TABLE gt_fmifiit

WHERE fikrs = '1000' and

rldnr = gc_rldnr and

gjahr = pa_fyear and

fistl IN so_fctr and

fonds IN so_fund and

fipex IN so_comm and

fares = ' ' and

measure IN so_fprog and

wrttp IN (gc_wrttp_54,gc_wrttp_61,gc_wrttp_66,gc_wrttp_57) and stats = gc_ststs and

I have maintain index which i have specified in where condition.

can u help to reduce the time.

Thanks,

Deesanth.