MySQL doesn't use index in join query
- by Kocsonya Laci
I have two tables: comments(id(primary key), author, ip(index)) and visitors(id(primary key), date_time, ip(index))
I want to join them like that:
SELECT visitors.date_time
FROM comments
LEFT JOIN visitors ON ( comments.ip = visitors.ip )
WHERE comments.author = 'author'
LIMIT 10
It works, but very slow.. In EXPLAIN it shows that it doesn't…
