Episode-024 - Adding a Functional Index in MySQL

6 Views
Published
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
Category
MySQL
Tags
MySQL, Database, Open-source
Be the first to comment