|
thanks for the responses. It is a Mysql 5 db. I'm not doing any subqueries in it.
I ran explain and it appears that it only does this when I use either group by or order by on the table. How would I optimize this better? I do have indexes on the fields being used in both the group by and order by for the table in question.
|