To add non-clustered indexes to your exMon DM tables press the Table Designer(1).

Then press Edit Indexes...(1).



To add or remove indexes press add or remove at the bottom of the index bar.


To add or remove columns in an index have your index selected in the index bar(1) and the column you want to add selected in the available columns grid(2) and press the add or remove buttons(3).


You can adjust the properties of index columns in the selected column grid, their sort order, or whether their data is only included with the index.


To change the order of columns in the index you can press the buttons at the bottom of the selected column grid. The order of columns in an index will affect the performance and effectiveness of your index.