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 dynamic Optimize property. This dynamic property is added to the Field object’s Properties collection when you set the CursorLocation property to adUseClient. 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.