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.
![SQL Server indexes defined in Luna Modeler](https://www.datensen.com/blog/wp-content/uploads/indexes-sql-server.webp)
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.
![Indexes displayed in ER Diagram for SQL Server.](https://www.datensen.com/blog/wp-content/uploads/sql-server-indexes-er-diagram.png)
#