Re: Simple Query - No Join - But Temp. Table and file Sort :(

[Toa Sty]

 
 Using code like this will work be a bit like <pre> :)  




As for the query, not sure how you can make it not use temps and filesorts off the top of my head. If you were using = rather than >= you wouldn't be seeing them as your evdate_2 index would be used. 





If you're not bothered about the order of the results (after grouping) you could add 'order by NULL' to drop the filesort but you'll probably not see much noticeable performance increase if any.








Actually - how come you're doing a GROUP BY but not using any aggregation functions (eg SUM, COUNT, MIN) on the non-grouped cols?  You'll be getting unpredictable values for evdate and loc (unless they're always the same for any value of lockey, in which case you're data might be in need of normalisation, and if you normalise you won't need the GROUP BY :)





Toasty



-----------------------------------------


email: 'toasty'*3 at gmail