|
|
|
|
|
|
by matt-snider
1897 days ago
|
|
|
MySQL 8.0 actually added support for functional indexes, but I found out the hard way that they don't work the same way as indexing generated columns. For me the biggest issue were the caveats around using the indexed column in conditions, which resulted in the index not being used in surprising situations. Anyways, I had to revert to generated columns which was a shame because it was a feature I had looked forward to using. I found this article on the topic to be helpful: https://saveriomiroddi.github.io/An-introduction-to-function... |
|
|