Table indexes

 

Note: this page is outdated. Please visit MariaDB indexes

How to work with database indexes in Luna Modeler

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

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.

#