The Jet Data Manager is capable of adding indexes on tables in the data warehouse and staging databases. Knowing what an index is and how an index works involves a little knowledge of database theory, but an excellent overview of the topic can be found at the following website (external link).
This article covers the creation of non-clustered indexes using the Jet Data Manager.
1. Verify that the "Physical Valid Table" option is enabled on the table by going to
Advanced >> Advanced Settings >> Physical Valid Table
2. Navigate to "Index Settings" by going to Advanced >> Advanced Settings >> Index Settings
. Give your index a descriptive name, and select fields on the left for the values that will comprise the index. Fields on the right, in the Include Fields column, may be selected as well. Items on the right will not be part of the index, but are still stored with the index. For instance, in the example below, the fields on the left are uniquely specifying a transaction, and the fields on the right are fields that we have instant access to should we decide to use it as a filter in a report, because fields on the right are stored with the index.
4. If desired, change the sort order. When completed, click Close .
5. Note that the table has a new node, titled
, containing the fields we selected above. Also, we can see that, in our example, ITEMID is not in the index, because it was added as an Included Field.