Setting up suggested indexes

Suggestions for composite indexes are made by scanning import specifications for discriminators. Given the performance impact, you should only create indexes for types of items that you intend to import regularly.

About this task

Suggestions scan all import specifications for index combinations that haven't already been implemented. As import specifications can import links, these suggestions may be made for multiple item types, and subsequently multiple indexes.

Procedure

  1. Select Tools > Database Design > Composite Indexes.

  2. Click Suggestions to list possible composite indexes that are suggested based on the discriminators selected in available import specifications.

  3. Click the Add Composite Index checkbox to select any import specifications that you want to use the suggested indexed fields.

  4. Click Add Indexes.