Skip to Content
0
Former Member
Apr 21, 2009 at 04:56 AM

How to improve Performance for Select statement

27 Views

Hi Friends,

Can you please help me in improving the performance of the following query:

SELECT SINGLE MAX( policyterm ) startterm INTO (lv_term, lv_cal_date) FROM zu1cd_policyterm WHERE gpart = gv_part GROUP BY startterm.

Thanks and Regards,

Johny