Timeline for Straightforward inner join is slow despite using indices and ref/eq_ref types
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 22, 2023 at 4:10 | comment | added | mgiuffrida | Actually the optimizer has stopped using the new index. Time is still about the same. | |
| Feb 22, 2023 at 3:48 | comment | added | mgiuffrida |
Thanks! I've added some info to the end of my question. Your suggested models index isn't used unless I force it, in which case the result is slightly slower. The optimizer does pick your activations index, but the time (and EXPLAIN ANALYZE output) is about the same.
|
|
| Feb 22, 2023 at 3:04 | history | answered | Rick James | CC BY-SA 4.0 |