Skip to Content
0
Former Member
Apr 09, 2010 at 08:58 PM

Performance for COEP and COVP select statement

348 Views

Hi All,

I am having performance issue with all programs where ever there is a select statement reading data from COEP and COVP table.

COEP and COVP table is having merely more than 100 Million entries in table and its growing every month with 8 Million new entries.

I am working on archiving of COEP as well but meanwhile I have to improve all the select queries, do we any ideal way to achieve it.

Thanks