event.eventdate (as any other column used for a range selection, i.e. >=, <, BETWEEN, etc.) must be made a 1st column of a clustered index on the table. Or - if there are 2 or more such columns in the table - 1st column of a covering index.