Relational database indexes are used to bring back a number of records based on specific
database columns. To increase the speed of record retrieval, you can create a composite index that
combines the values of fields that contain related information.
About this task
Composite indexes are a feature of Microsoft™ SQL
server databases that improve the retrieval times of records by allowing data to be retrieved
without the need to open the record table. To create a successful composite index, you need to pay
attention both to the types of fields that you add, and to the ordering of those fields. You want to
create index entries for the most common terms to be associated, in the order that they are most
likely to be run. For example, if you would like to add composite indexes to improve the performance
of running queries, align the fields in your index with the discriminators that are used in the
import specifications.
Procedure
-
Select .
- Choose Record Type that you would like to create a composite index
for.
- Select Add.
- For each index combination that you would like to add for this record
type:
- Select Add.
- Choose the Key Fields to use and press
OK.
- Choose the Included Fields to use and press
OK.
- Click OK
The index is created but can be
deleted.
- Continue to create indexes for other record types by repeating steps 2 - 4.
- Click Close.
