The ADO client-side cursor library provides the capability to dynamically create indexes on fields in local record sets. An index can dramatically improve performance when finding or sorting data in a local record set. Client-side Field objects include a dynamic property called Optimize, and if you set the Optimize property to True an index will be created on the field. Once you have created an index, you can delete the index by setting the Optimize property to False. Because it is a dynamic property, you can only access this property through the Properties collection of the Field object..