Listing 1: Creating a Copy of the Sales.SalesOrderHeader Table with Four Indexes

USE AdventureWorks
GO
SELECT * INTO SalesOrderHeader
FROM Sales.SalesOrderHeader
GO
ALTER TABLE SalesOrderHeader  ADD CONSTRAINT
   [PK_SalesOrderHeader_SalesOrderID]
   PRIMARY KEY CLUSTERED
([SalesOrderID])
GO
CREATE NONCLUSTERED INDEX
   [IX_SalesOrderHeader_CustomerID]
   ON [SalesOrderHeader]
([CustomerID])
GO
CREATE NONCLUSTERED INDEX
   [IX_SalesOrderHeader_SalesPersonID]
   ON [SalesOrderHeader]
([SalesPersonID])
GO
CREATE NONCLUSTERED INDEX
   [IX_SalesOrderHeader2_ContactID]
   ON [SalesOrderHeader]
([ContactID])
GO