saimsaboor (5/2/2008)

---

In the "where" Clause the "datename" function is Nondeterministic function also when we use "like" operator then query can not use indexes on that key resulted in table scan rather than index seek.

I will prefer the Case Statement

i.e.

where

case month(dob)

when 1 then 1

when 3 then 1

when 4 then 1

when 5 then 1

when 7 then 1

when 8 then 1

else 0 end = 1

In the above statement month is used which is deterministic function and this query will take part in index seek.

Saim