Hi,
This statement is causing performance issue. Kindly suggest me the changes for further improvement.
form get_eeo_aap_categories using p_plans
p_date
p_aap_cat
p_eeo_cat.
tables: t5u29.
clear t5u29.
select: eeoct
aapct
from t5u29
into (t5u29-eeoct,
t5u29-aapct)
where plans = p_plans
and endda >= p_date
and begda <= p_date.
exit.
endselect.