>Is there anyway to set an index on a fox table through ado before you run a sql command through ado. I have several large queries that I am trying to run through VB/ADO and was wonding if this was a way to get my response time down.
>
>Thanks
>Darren

Also, you should check the VFP docs regarding the ODBC driver to ensure that your queries are optimizable through the driver. The ODBC driver is not able to optimize queries in all the same ways that native VFP is.