"SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID."

There have obviously been too many trick questions lately, as I thought this was one as well!

SQL Server does have an efficient way to retrieve rows based on a known value for PersonID, and here it is:

create index indPersonID on Persons (PersonID)

😉