Optimize Property

Sets or returns whether an index should be created on a database field.

object.Optimize as String

Notes

This property is only available when the Server property for the corresponding Connection object is set to DBServerADO, and the CursorLocation property for the corresponding Recordset object is set to DBUseClient.

An index can improve the performance of the DBFind action. 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.

See Also

DBSeek action

Applies To

Field object

---

© 2004-2021 looksoftware. All rights reserved.