Sunday, 12 October 2014

Create Indexes with Included Columns

CREATE NONCLUSTERED INDEX IX_Address_PostalCode
ON Person.Address (PostalCode)
INCLUDE (AddressLine1, AddressLine2, City, StateProvinceID);
GO

No comments:

Post a Comment