Date index for Jun 2003

When i select a week report i get the following error:


error: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok (errno: 1104)
error: Invalid SQL: SELECT (uc_hours*60)-sum(time) as leftover FROM hours LEFT JOIN usercontract ON hours.userid = usercontract.userid WHERE startdate <= '2003-06-02' AND enddate > '2003-06-02' AND hours.userid = 'lennaert' AND activitydate between '2003-06-02' and '2003-06-08' GROUP BY hours.userid 


a few other people have this problem as well, i gathered that it has something to do with the user having admin rights, but could not find a fix for it.

Lennaert Roomer