A new create index syntax
CREATE MULTIVALUE INDEX allows you to create a functional index on arrays of strings or numbers within a JSON type column. Each unique value within the array will become a searchable index entry.
This avoids the need for full JSON scans to find values within arrays in JSON columns, when searched using the
JSON_QUERY operators. It provides similar benefits to conventional functional indexes when searching JSON, but conventional functional indexes are limited to a single indexed value per row.