Table indexes

 

Note: this page is outdated. Please visit page MariaDB indexes

 

Working with Indexes in Luna Modeler

To add a new index to a database table, edit your table, navigate to tab Indexes and click + Add Index.

mysql table indexes

Then it is necessary to add columns to the index. Click +Add Column to Index to display a dropdown with a list of available column names. Pick a column and then specify other index properties.

MariaDB Index

#