title: Clustered index on temp table
body: <p>I'm trying to optimize a procedure that has code like the following:</p>
  
  <pre><code>CREATE TABLE #t1 (c1 int, c2 varchar(20), c3(varchar(50)...)
  
  CREATE CLUSTERED INDEX ix_t1 ON #t1(c3) ON [PRIMARY]
  </code></pre>
  
  <p>I wanted to improve that by moving the CLUSTERED index into the table declaration (more caching friendly), but c3 is not unique so this doesn't work:</p>
  
  <pre><code>CREATE TABLE #t1 (c1 int, c2 varchar(20), c3 varchar(50)..., UNIQUE CLUSTERED (c3))
  </code></pre>
  
  <p>Is there a way to declare a clustered that is not unique in the temp table declaration?</p>