In this example we created an index on the OrderDate indescendingorder. We will drop the index and recreate it. DROPINDEX[IX_PurchaseOrderHeader_OrderDate]ON[Purchasing].[PurchaseOrderHeader]GOCREATENONCLUSTEREDINDEX[IX_PurchaseOrderHeader_OrderDate]ON[Purchasing].[PurchaseOrderHeader]([OrderDate]de...