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

[Heiko G.]

Hi Toasty,

the last Example works fine for me :) Last Thing I dont get is that I have to set the index (group_field,where_field). In almost all other threads about indexes, the indexes are set like (where_field(s),group_field(s)) ?!

Since iam kinda new to indexes and DB design I also used the kind (where_field(s),group_field(s)) where I could which improved Performance in many cases. But is it possible that, if I would use indexes like (group_field,where_field), the performance would be even better ?

I will try this in the other query, which I posted as Reply to Ravenous B.B., mabye this explain why it dont use a Index at all :)

Thx
Heiko