First about index selection where if your WHERE criteria doesn't include the first column in a non-clustered index the server will NOT use the index. i.e.: You search for CustomerID, Customer Last ...