Thanks for the suggestion, but according to explain we are in worse shape
than before. In both cases the multi-column index is ignored. I am going to
try fiddling with the index col order to see if this helps.
Here is what it comes up with as you suggested:
Query1:
explain SELECT COUNT(*) as Nu
Afternoon all. I wonder if any experts on the join optimiser could help me
out. I have read the docs, including the material on how mysql optimises
joins, and have redesigned my schema somewhat to try and simplify the joins,
and that has worked to some extent. But I am still way off the performance
