Timeline for Create Index for specific value in mysql column
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 28, 2022 at 15:00 | history | tweeted | twitter.com/StackDBAs/status/1608115561824747520 | ||
| Dec 27, 2022 at 16:53 | vote | accept | MohammadAli Zeraatkar | ||
| Dec 27, 2022 at 16:21 | answer | added | RolandoMySQLDBA | timeline score: 1 | |
| Dec 27, 2022 at 15:22 | review | Suggested edits | |||
| Dec 28, 2022 at 8:17 | |||||
| Dec 27, 2022 at 13:56 | comment | added | Akina |
Use partitioning. Or at least test .. WHERE num < 50. Also you may try to force the index usage.
|
|
| S Dec 27, 2022 at 12:55 | review | First questions | |||
| Dec 27, 2022 at 12:59 | |||||
| S Dec 27, 2022 at 12:55 | history | asked | MohammadAli Zeraatkar | CC BY-SA 4.0 |