2 ms·
Yeah, I would think functional/function-based indexes should be mentioned. Add an index or add a redundant column? Almost all of time I would prefer the index
by shrdlu2 3y ago
Yeah, I would think functional/function-based indexes should be mentioned. Add an index or add a redundant column? Almost all of time I would prefer the index.
Of course if your database can't be changed then maybe you can use this trick if there is already a suitable indexed column.
- aarondf 3y agoYeah I could definitely add some links to or descriptions of functional indexes. If you're curious, here's a video I did on it: https://planetscale.com/courses/mysql-for-developers/indexes/functional-indexes https://planetscale.com/courses/mysql-for-developers/indexes...