又是一个硅谷招聘的VB数据库试题

efoxxx 2001-11-29 03:40:20
Assuming that: Dim RS As ADODB.RecordSet, why would the following statement change the performance of a VB program?
RS.Fields(“Customer”).Properties(“OPTIMIZE”) = True
...全文
52 1 打赏 收藏 举报
写回复
1 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
playyuer 2001-11-29
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.
  • 打赏
  • 举报
回复
相关推荐
发帖
数据库(包含打印,安装,报表)

1200

社区成员

VB 数据库(包含打印,安装,报表)
社区管理员
  • 数据库(包含打印,安装,报表)社区
加入社区
帖子事件
创建了帖子
2001-11-29 03:40
社区公告
暂无公告