title: sql server index rebuild slows first query
body: <p>Database is SQL 2008R2 Enterprise.</p>
  
  <p>I have an SSIS integration that truncates and loads about 15 million rows in a table each night.  After that happens, I have an Execute SQL Task that rebuilds an index on the table b/c it is severely fragmented after the trunc and load.</p>
  
  <p>The issue I have is the first time a report using that table as a datasource.  The first execution takes a while.  After that first execution however, the report is blazing fast as expected until the next night when the truncate and load and index rebuild happens again.</p>
  
  <p>Any recommendations on what I can do fix the performance on the first query on that table?</p>