Viewing 2 posts - 1 through 2 (of 2 total)
Yes, I have tried many different options like this, but I have the restriction of not having any "Value" inside the subquery. Describing the problem:
TableA
01 Part1
02 Part2
03 Part3
04 Part4
05 Part5
TableB
500...
March 11, 2003 at 12:52 pm
#450827
Thanks. I've checked and there are very different showplans. It takes 89% of time to filter through the variable. I will continue trying.
February 20, 2003 at 5:27 pm
#449444