Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
VrRam
VrRam
1 Post
ACCEPTED ANSWER

Pinned topic Performance issue when retrieving the data from an Archive collection

‏2012-08-24T17:20:49Z |
Hi,

Table T1 has 60+ mn rows in a archive collection. There are some duplicate records in table T1 (say about 0.001% records). So I have created vitural view in Optim connect (Attunity) with SELECT DISTINCT statement and it works. But the performance is very poor when retrieving the data from Table T1.

Is there way to improve performance?

Any suggestions please

Thanks
Ramana