To add a new SQL Server index to a database table in Luna Modeler, edit your table, navigate to tab Indexes and click + Add Index.
Then 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.
Index types
The following index types are supported:
- Relational
- Spatial
- XML
- Columnstore
Display mode & Indexes
You can activate index display instead of column details. Click the Display button on the main toolbar and select Indexes.
#