create table Customers ( CustomerID int primary key nonclustered, FirstName varchar(30), LastName varchar(30) ); create clustered index LastName on Customers (LastName)