Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Sotiris Filippidis Conditional Statements in WHERE Clauses RE: Conditional Statements in WHERE Clauses
Adam Machanic
SSCoach
Points: 15370
More actions
July 26, 2004 at 11:08 am
#516131
thormj,
The problem is that unfortunately that query will be unable to seek indexes as the optimizer will evaluate ALL of the possible conditions (therefore, a scan will be necessary).
--Adam Machanicwhoisactive