>>The table is also indexed on site_id, rosterdate and rosterdate>=date().
>
>The index on rosterdate>=date() is not needed for your query. I'm also wondering if it has any practical use. How does it work - as date() changes every day?

Well, good point. Still leaves the problem though.