I have been struggling with these problem for many days. I would be very grateful if someone could help me out.
have two tables like below:
post_id int(11) (primary key)
post_tag_id bigint(20) (primary key)
FROM posts, post_tags
WHERE posts.post_id = post_tags.post_id
AND post_tags.tag_id IN ( 3, 1186, 676, 568, 75 )
ORDER BY post_date DESC
I experimented with making few indexes but not able to remove the warning - “Using where; Using filesort”.
Can someone help me to find right indexes on my tables so that I could get the data only through indexes (no where, no temporary, no filesort message).