Comments - Index/optimizations in Dynamic Columns
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Yes, currently dynamic columns can't be easily indexed. You 'can' do an index with the help of a virtual column, but that is not that convenient as you then duplicate the information for that column.
Adding indexes for dynamic columns is something we plan to do if the usage of dynamic columns picks up and there is a demand for it. MWL#215 was created for this task.