I got a script to create an index, but IDEA don't set the index, the default is no index, is there a way to force IDEA to use a specific index?
Function IndexDatabase(DatabaseToBeOpened As String, FieldToBeIndexed As String, IndexKey As String)
Set db = Client.OpenDatabase(DatabaseToBeOpened)
Set task = db.Index
task.AddKey FieldToBeIndexed, IndexKey
task.Index FALSE
Client.CloseDatabase(DatabaseToBeOpened)
Set task = Nothing
Set db = Nothing
End Function
Robert van den ...
Offline
Last seen: 2 years 11 months ago
Joined: 08/08/2018 - 07:37
If you leave the database open you will keep the index that you just created.