Hi,
We are performing a sparse lookup on a table, with input data around 1 Million records. The performance of the lookup is very very slow.
The reference table has got around 500Million records. and the table is indexed.
Can any one please suggest a solution to resolve this problem?
Thanks !!!
Sparse lookup Performance slow
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You asked the same question in the General forum; I answered it there.
Yes, here is probably the more appropriate forum, but what's done is done.
Yes, here is probably the more appropriate forum, but what's done is done.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.