title: Can creating a primary key on a #temp table increase proc speed?
body: <p>If you create a primary key on a large #temp table,
  or perhaps a few other indexes, what are the potential speed benefits, and what are the potential slowdowns? </p>
  
  <p>Is it normally a good idea to this with a large #temp table? </p>
  
  <p>I've seen one article referenced in another stackoverflow question, 
  <a href="http://www.sqlteam.com/article/optimizing-performance-indexes-on-temp-tables" rel="nofollow">http://www.sqlteam.com/article/optimizing-performance-indexes-on-temp-tables</a>, 
  but it doesn't give much of an explanation. </p>