Online Documentation for SQL Manager for SQL server

Managing indexes


The Indices tab is provided for viewing indexes represented in the view. Double-click an index to open Index Editor for editing the index.

 

Right-click an index to display the context menu allowing you to create new, edit, drop, enable/disable the selected index, or enable/disable all indexes. Using the menu you can also export the list of the view indexes to any of supported formats.

 

View Editor - Managing indexes

 

 

The Indexes list provides the following attributes of each index of the view:

Index Name

Columns

Clustered

Primary Key

Unique

Disabled

 

For details see Indexes.

 

If necessary, you can also use the Index Description area to supply a description for each index.