Can anyone help with the following. I am connecting to my table using odbc through VBSCRIPT.

1. When you create an index on a table using odbc, do you use an alter table
statement? Does this create an idx / cdx file?
2. When you use odbc to update the table, does odbc maintain the index?

Thanks in advance