Hi,
SQL version: 4.1.21
This query:
SELECT t.tid, t.title, t.starter_name, t.starter_id, p.post_date, p.post, p.pid
FROM freeto_topics t
LEFT JOIN freeto_posts p ON (p.new_topic = 1 AND p.topic_id = t.tid)
WHERE t.forum_id IN (7,3,26)
AND t.approved=1
ORDER BY t.tid DESC
LIMIT 0, 15
is used on a forum. it seems to be doing a filesort. here is the EXPLAIN for this query:
How can I get rid of this...? forum_id has an index on tid so I dont understand why it's doing a file sort. More info can be posted if needed, I'm confused with this index stuff and I've read the manuals, but I need some help.
Thanks in advance.