Aikesheng Open Source Community
Feb 3, 2021 · Databases
Understanding MySQL Functional (Expression) Indexes
The article explains MySQL functional (expression) indexes, how they are implemented via generated columns, demonstrates their creation and performance benefits for datetime and JSON fields, compares them with prefix indexes, and offers guidance for older MySQL versions.
JSON IndexMySQLSQL optimization
0 likes · 12 min read