| title | Optimize Property-Dynamic (ADO) | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| apitype | COM | |
| helpviewer_keywords |
|
|
| ms.assetid | a491c4ce-2b04-4c84-be83-3846bde8d16b | |
| author | MightyPen | |
| ms.author | genemi |
Specifies whether an index should be created on a field.
Sets or returns a Boolean value that indicates whether an index should be created.
An index can improve the performance of operations that find or sort values in a Recordset. The index is internal to ADO; you cannot explicitly access or use it in your application.
To create an index on a field, set the Optimize property to True. To delete the index, set this property to False.
Optimize is a dynamic property appended to the Field object Properties collection when the CursorLocation property is set to adUseClient.
Dim rs As New Recordset
Dim fld As Field
rs.CursorLocation = adUseClient 'Enable index creation
rs.Fields.Append "Field1", adChar, 35, adFldIsNullable
rs.Open
Set fld = rs.Fields(0)
fld.Properties("Optimize") = True 'Create an index
fld.Properties("Optimize") = False 'Delete an index
Optimize Property Example (VB)
Optimize Property Example (VC++)
Filter Property
Find Method (ADO)
Sort Property