Timeline for Read performance when indexing one column vs indexing multiple columns
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 16, 2023 at 2:10 | comment | added | Rick James |
If you have INDEX(a,b,c), it is almost always wasteful to add INDEX(a). Indexes are stored in disk (and cached in RAM -- the buffer_pool).
|
|
| Jan 24, 2018 at 13:50 | history | answered | ttwis | CC BY-SA 3.0 |