Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Performance for COEP and COVP select statement

Former Member

‎2010 Apr 09 9:58 PM

0 Likes
847

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

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

Reply
1 REPLY 1
Read only

Former Member

‎2010 Apr 09 10:04 PM

0 Likes
499

Moderator message - Please see before posting. You have to do some work and post the results of your analysis if you expect any useful help. Post locked Rob