optimizing the code for better performance

Dear Frds,

The program performance is getting degraded because of the below select statement which fetches the OBJECTID from CDHDR table for the given period and the T code VA02.

select objectid

from cdhdr

into table gt_itab

where objectclas in lr_objectclas

and objectid in lr_objectid

and changenr in lr_changenr

and username in lr_user

and udate in s_date

and utime in lr_utime

and tcode = 'VA02'.

we have tried with the primary key sequence and also by selecting the distinct data. Still it is taking more time.

Please do needful to tune this for better performance.

Regards,

Sailaja.