Adding an Index to a Query

Use this procedure to include an index in a database or form query. The use of an index can improve the processing time for the query, if the index structure corresponds well to the data you want to retrieve. Indexes in this case are more efficient than filters.

If you do not specify an index in the query, the query uses the primary index to retrieve records (usually, xxxSET1).

To add an index to a query

  1. Define the basic query.
  2. In the lefthand pane, expand the list of indexes available for the query's file and double-click the index you want to use.
  3. Optional. Provide values for the index key fields.
    1. In the left pane double-click on any field listed beneath the index, or in the Properties view for the query, right-click the index and select Set Index Key Values.

      The Set Index Keys window appears.

    2. Type a value for each key.
    3. Click OK.