Saturday, November 19, 2011

SQL Server - Create indexes on Temp Tables

-------------------------------------------------
--Create temp table to hold values
-------------------------------------------------
CREATE TABLE #myTempTable
(
     ID       int
   , customer varchar(50)
)

-------------------------------------------------
--Create Clustered Index on the ID
-------------------------------------------------
CREATE CLUSTERED INDEX #IX_myTempTable_ID
     ON #myTempTable ( ID )

-------------------------------------------------
--Create Index on customer
-------------------------------------------------
CREATE INDEX #IX_myTempTable_Customer
     ON #myTempTable ( customer )
 
-- Note:  When you drop the table, 
--        the indexes will be dropped at the same time.

No comments:

Post a Comment