title: Improve performance of Temp table insert (with lots of columns)
body: <p>I have to create a temp table #Trades from a select query. The select query returns  77,987 rows and have about 175 columns (mix of varchar, numeric, small int and int).</p>
  
  <p>I am current using the following query to create the temp table:</p>
  
  <pre><code>SELECT Col1, Col2 ... Col175 into #Trades From Table
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/ubNz5.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ubNz5.jpg" alt="enter image description here"></a></p>
  
  <p>As per the query plan, the Table Insert takes the most amount of time. </p>
  
  <p><a href="https://i.stack.imgur.com/H3e06.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H3e06.jpg" alt="enter image description here"></a></p>
  
  <p>Also, Estimated Rows count does not match with Actual Rows.</p>
  
  <p>Is there anyway I can improve the performance of the query used create #Trades temp table?  </p>
  
  <p>PS: I tried creating a temp table using create table and changed the query to insert into the temp table but it did not help much. </p>