0

I've noticed that when I have a complex query, if I select into a temp table or create a new table from the query, the query seems faster to process then if I did not. I'm wondering if anyone else has noticed this effect, and could provide a reason for it?

rottentomato56
  • 1,059
  • 3
  • 13
  • 18
  • Not really answerable without more details but some possible suggestions [Here](http://stackoverflow.com/questions/18765738/how-can-i-force-a-subquery-to-behave-like-a-temp-table) if you are talking about breaking up the query with `#temp` tables. – Martin Smith Oct 04 '13 at 17:29
  • It is. http://beyondrelational.com/modules/2/blogs/115/posts/11142/select-into-is-faster-than-create-amp-insert.aspx – Yuriy Galanter Oct 04 '13 at 17:30
  • 1
    @YuriyGalanter - The OP should supply an example of what they mean IMO. – Martin Smith Oct 04 '13 at 17:35
  • Are you talking about select into being faster than not using any form of extra table at all? Or just that select into is faster than create temp table + insert? – Joel Coehoorn Oct 04 '13 at 17:44

0 Answers0