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

[Ravenous Bugblatter Beast]

Including the date in the select list is what requires both a temporary table and filesort. It also ambiguous unless you select MIN(e.evdate) or select MAX(e.evdate) - if a location has many events in the future, which date do you want - the first event or the last event or any random event?

If you can live without including the date in the result set you can avoid the filesort (but not the temporary table) using:

select distinct e.lockey,e.loc FROM sc_events e WHERE e.evdate >=1161428363