>>The indexes were listed at the bottom of the original post.
Woops, didn’t see that far down, should have scrolled a little further :)
>>What is needed, I expect, is a
>>multi-column index on those 2 columns:
>>
>> ALTER TABLE 31909_859552
>> ADD INDEX Tag_Created (`Call Svc Tag ID`, `Jou
You have a redundant clause in your query - the distinct is not needed when
you are doing a group by on the same field ('Call Svr Tag ID') - not sure
how the optimiser in MySQL will handle this. In some RDBMS's the duplicate
clause will be optimised down to 1 clause, so you wont cop a performance
h
