Hi,
Does changing the partition for a Sparse lookup have any effect, since it is directly firing the queries to the DB?. I have all the stages with Auto partition, but just wanted to know whether changing the partition for a sparse lookup will have any impact.
sparse lookup partitioning
Moderators: chulett, rschirm, roy
No, this should have no effect on the lookup behaviour whatsoever, though I would have some suspicion that using Entire might result in multiple matching, if your lookup runs in parallel. Definitely best you stick with Auto - is there some reason why you are thinking of changing this?
Last edited by miwinter on Wed Aug 05, 2009 3:35 am, edited 1 time in total.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>