Hi Malcolm,
>>Seems to me there may be a more effective way to accomplish this?
I was trying to optimize an aggregate subquery and I don't think I could.
Do indexes need to be created is some special way? Is there a way to
control the optimizer to force it to use or not to use an index?
Does it seem that using scan and inserts can actually work faster in
such a case?
Thanks for the puzzle and thanks to SQL Masters for all the useful tips.
-Vera
©2005 Vera Silin |
