Creating indexes in a physical data model with a wizard

With a wizard, you can create indexes with the same properties as a template index in a physical data model. Use the wizard instead of the Data Project Explorer, the Properties view, or a physical data model diagram to save time when you work with large physical data models.
Before you begin
Prerequisite: You must create one index in a physical data model to use as a template. You can create a new index by using one of the following methods:
About this task

To create new indexes in a physical data model by using a wizard

  1. Right-click an index object in a physical data model from the Data Project Explorer, and select Apply Index. A wizard opens.
  2. Complete the wizard steps.
    1. On the first page of the wizard, you can select a different index to use as a template.
    2. On the second page of the wizard, you select the constraints to which the selected index should be applied, and specify a naming convention for the new indexes.
  3. Click Finish.
Results

The new indexes are created and displayed in the Data Project Explorer.


Feedback