Listing 1: Creating a Copy of the Orders Table with No Clustered Index

USE Northwind
GO
SELECT * INTO Orders2
FROM Orders
GO
CREATE INDEX CustomerID2
  ON Orders2(CustomerID)
GO





1