Hi,

I have table with one of its column(Created_Date) as smalldatetime, having index created on it.

Now I have to query this table to get all records with created_date equal to some specific date. I am using following query for this

select * from table_name where dateDiff(d,@varDate,Created_Date) =0

But this query doesn't seems to be optimized as its not making any use of index created on Created_Date.

Can any one help me on this.