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
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:
- In the Data Project Explorer, right-click a database object in
a physical data model, and click . From the sub menu, select an index.
- Drag and drop an existing index from a database connection in
the Database Explorer to the physical data model.
Procedure
To create new indexes in a physical data model by using
a wizard:
- Right-click an index object in a physical data model from
the Data Project Explorer, and select Apply Index. A wizard opens.
- Complete the wizard steps.
- On the first page of the wizard, you can select a different index
to use as a template.
- 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.
- Click Finish.
Results
The new indexes are created and displayed in the Data Project
Explorer.