Skip to Content
0
Former Member
Mar 25, 2009 at 09:23 AM

Performance issue

24 Views

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.