Reindex 1

[TLowder]

Do you need to reindex an existing index as data is added to the table or is it just a one time thing? If so what is the syntax for reindexing or do you delete the index and create it again?

I'm using an adodb connection and execute the following sql statement. If I run the statement more than once I get an error - duplicate key name.

"Create Index SomeField on SomeTbl(SomeField)"

Thanks,
Tom

 

[TonyGroves]

After you create an index you can forget about it; it will be kept up-to-date automatically.

 

[TLowder]

Thank you,
Tom