Re: Multiple queries into a single temp table

Jay Hannah wrote: > > Could someone tell me about performance of each approach ?. > > Which solution is more preferable with terrific amount of data in each select > > My completely uneducated guess would be that with very large amounts of > data, the second method may be faster since it ties up less memory per > transaction... > > If I were you, I'd just run them both and see which one completes faster > (but I'm goofy like that). > With that kind of solving problem I'll just get the unswer in my own specific conditions (OS, ONCONFIG etc.) I want to know the general answer. -- If You want to feel OK -- INSTALL Your Windows Every Day !