How can I efficiently search for all records from a given month, or a given year?
Why not the classic way to avoid functions 

WHERE startDate BETWEEN '2014-01-01' AND '2014-12-31';


or

WHERE startDate LIKE '2014-01-%' ;