Timeline for What is the ideal composite index for this query?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 9, 2016 at 6:11 | comment | added | Rick James | Separate indexes is not as good as a composite index in this case. | |
| Mar 9, 2016 at 3:08 | comment | added | ProgrammerGirl | Yes, I have separate indices on each of the individual columns in this InnoDB table. Instead of MySQL using the Composite Index, it's using the Intersect of the individual indices. What would you suggest? | |
| Mar 8, 2016 at 23:56 | review | First posts | |||
| Mar 9, 2016 at 2:15 | |||||
| Mar 8, 2016 at 23:54 | history | answered | EvanB | CC BY-SA 3.0 |