Timeline for MYSQL Indexes when looking up on alternating sets of columns
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 18, 2014 at 4:46 | answer | added | Jehad Keriaki | timeline score: 0 | |
| Mar 10, 2014 at 13:27 | answer | added | Jens D. | timeline score: 0 | |
| Mar 10, 2014 at 12:01 | review | First posts | |||
| Mar 10, 2014 at 13:31 | |||||
| Mar 10, 2014 at 11:50 | history | edited | Rich McPharlin | CC BY-SA 3.0 |
added 91 characters in body
|
| Mar 10, 2014 at 11:49 | comment | added | ypercubeᵀᴹ |
The 2 composite indexes you already have are sufficient for the queries you mention. And I think the DISTINCT is not needed in the 2nd query.
|
|
| Mar 10, 2014 at 11:43 | history | asked | Rich McPharlin | CC BY-SA 3.0 |