Timeline for Why is a query with a join and limit clause running so slow, even using a covering index?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 3, 2016 at 0:27 | comment | added | Rick James |
"I understand the JOIN doesn't seem to serve a purpose here". No. Even adding one column to the SELECT can completely change the EXPLAIN. Let's see the real query.
|
|
| Sep 3, 2016 at 0:24 | comment | added | Rick James |
Please provide SHOW CREATE TABLE. There is one useful "covering index" and one less useful.
|
|
| Sep 2, 2016 at 1:22 | answer | added | BillThor | timeline score: 0 | |
| Sep 1, 2016 at 19:27 | comment | added | ypercubeᵀᴹ | What indexes do you have? Show us the definition of both tables and the whole EXPLAIN output. | |
| Sep 1, 2016 at 18:53 | history | asked | timetofly | CC BY-SA 3.0 |