Episode-024 – Adding a Functional Index in MySQL

Functional indexes store the result of an expression rather than a value from a database column (or columns).

In this video, we discuss an example of where this may be helpful and demonstrate the syntax of creating a functional index in MySQL.
Functional Index Documentation:

– https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-functional-key-parts