Pinned topicPerformance issue when retrieving the data from an Archive collection

‏2012-08-24T17:20:49Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

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.