Create Custom Table Index

Created by: Gunnar Tómas Gunnarsson

In this article, you will learn how to create a custom table indexes. Custom table indexes can help improve the performance of your data in exMon DM.

Add non-clustered indexes to your exMon DM tables

  1. Click the Table Designer
  2. Then, select Edit indexes

Add or remove columns in an index

  1. To add or remove columns in an index have your index selected in the index bar
  2. Select the column you want to add from the available columns grid
  3. Click the add or remove buttons

 

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 click 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.

Gunnar is the author of this solution article.