City Index? Neither the code you posted or my code would even come near a "city" index if the Primary Key was the CustomerID column. Certainly, it wouldn't do a table scan if an index were present on CustomerID... Index Scan, yes... table scan, no.
The only reason I made the disclaimer about INT was because I didn't test it using VARCHAR.
--Jeff Moden
Change is inevitable... Change for the better is not.