Index Support and Find, Sort, and Filter

Indexes on fields can greatly enhance the performance of the new Recordset object Find method, and Sort and Filter properties. In ADO 2.0, you can create an internal index for a Field object by setting its new Optimize property. Remember that this index is internal to ADO 2.0ùyou can't gain access to it or use it for any other purpose.

The Sort property determines the order in which rows of a Recordset are traversed; the Filter property determines which rows are accessible when traversing rows; and the Find method quickly locates a value within an indexed column (field) of a Recordset.