title: Getting rid of Table Spool in SQL Server Execution plan
body: <p>I have a query that creates several temporary tables and then inserts data into them.  From what I understand this is a potential cause of Table Spool.  When I look at my execution plan the bulk of my processing is spent on Table Spool.  Are there any good techniques for improving these types of performance problems?  Would using a view or a CTE offer me any benefits over the temp tables?</p>
  
  <p>I also noticed that when I mouse over each table spool the output list is from the same temporary table.</p>