[Mysql: Index on date field not getting used]

Thank you Barand, this query is indeed a lot faster than the one I was using but even now when I do an explain, it doesn\'t use my date index? Why not? And why is this query much faster than the one I was using. Can you tell me?

[Mysql: Index on date field not getting used]

Hello,

 

I have a query that is very slow. This query used the date field to find urls that are less than 30 days old.

 

In order to speed up this query, I indexed the date field. Evem after the indexing the query results are slow and explain on select statement doesn\'t show that the index is getting used. Is there anyway I can make my select statement use the index. Here is my query

 

SELECT distinct r.res_id, r.resource_name,r.resource_url FROM links l, sections s, resources r WHERE l.sec_id = 62 AND r.res_id = l.res_id AND s.sec_id = l.sec_id AND to_days(now()) - to_days(r.update_date) <= 30 ORDER BY r.resource_name asc 

 

thanks

anna