Re: How can I get the 'EXISTS' or 'IN' use an index?

[Rick James]

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G
* SHOW TABLE STATUS LIKE 'tbl'\G
* EXPLAIN SELECT ...\G
and surround them with [ code ] and [ / code ]

Some ideas:

* Turn the IN EXISTS into a LEFT JOIN

* Create INDEX(who, created) and (created, who); then look at the EXPLAIN to see which one (if either) it uses.

I may have more clues when I see the SHOWs and EXPLAINs.