-------------------------------------------------
--Create temp table to hold values
-------------------------------------------------
CREATE TABLE #myTempTable
(
ID int
, customer varchar(50)
)
--Create temp table to hold values
-------------------------------------------------
CREATE TABLE #myTempTable
(
ID int
, customer varchar(50)
)
-------------------------------------------------
--Create Clustered Index on the ID
-------------------------------------------------
--Create Clustered Index on the ID
-------------------------------------------------
CREATE CLUSTERED INDEX #IX_myTempTable_ID
ON #myTempTable ( ID )
ON #myTempTable ( ID )
-------------------------------------------------
--Create Index on customer
-------------------------------------------------
--Create Index on customer
-------------------------------------------------
CREATE INDEX #IX_myTempTable_Customer
ON #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