>>> As long as your expressions are optimizeable by Rushmore, ADO will use the indexes on the backend to retrieve the data.
>>
>>Unless something has changed (it could have), I don't think the VFP ODBC driver uses Rushmore.
>
>I'm definitely a newbie at SQL-Server, but I thought that it handled all queries using it's own indexes. There's a message today (thread 293893) from someone who's having a problem with some queries using indexes and others not, but it's under SQL-Server's control not VFP's isn't it?
>
You're right, with a server database, it will decide when to use its own indexes. But when getting VFP data with ADO (IOW- through the OLE-DB provider for ODBC datasources), which is what I thought the question was about, you are going through the VFP ODBC driver, which I don't think knows how to optimize a query. (It seems Rushmore is deeply dependent on the intimacy between the VFP environment and its data, and cannot be utilized when the data is separated from the environment by the ODBC layer).
Erik Moore
Clientelligence