SELECT ... INTO with clustered index ?

• ThomasH

  SSCertifiable

  Points: 7437

  More actions

  December 9, 2003 at 4:00 pm

  #106656

  Is there a syntax for SELECTing INTO a table where the new table has a clustered index?

  Instead of two separate commands like:

  SELECT Col1, Col2, Colx INTO NewTable

  CREATE CLUSTERED INDEX NewTableClus ON NewTable (Colx)

  If so, does this provide a performance enhancement over the two command syntax especially when NewTable is a #Temp table?

  
  
  Once you understand the BITs, all the pieces come together

• mccork

  SSC-Insane

  Points: 22288

  More actions

  December 10, 2003 at 12:02 am

  #485469

  'fraid not.

  Cheers,

  - Mark

  
  Cheers,
  - Mark