How can I rewrite this SQL statement to not use OR statements in the WHERE clause and make it as efficient as possible? Its an interview question.

Question

SELECT id name city FROM people WHERE title = 'Manager' OR city = 'Boston' OR HireDate > '1/25/04'

Justin N · Answer

3) ************************************ Assuming a large table with indexed search fields rewrite the given query to not use OR statements in the WHERE clause. Try to make it as efficient as possible. SELECT id name city FROM people WHERE title = 'Manager' OR city = 'Boston' OR HireDate > '1/25/04' SELECT id name city FROM people WHERE title = 'Manager' OR HireDate > '1/25/04' this is the exact question

Suthish Nair · Answer

I think didnt understand your thread properly..