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
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
- Category
- MySQL
- Tags
- MySQL, Database, Open-source

Be the first to comment