>Will the VFP OLEDB provider use rushmore optimization (where it can) for queries?
>
>For example, assume a CDX file has a tag created from:
>INDEX on FIELD1+FIELD2+FIELD3
>and your SQL WHERE clause that you pass to the OLEDB provider is structured like:
>WHERE FIELD1+FIELD2+FIELD3="SomeCharacterString"
>
>Just to emphasize, I'm not asking about the VFP.EXE application or the VFP runtime support libraries. This question is about the VFP OLEDB provider. Thanks very much.
The rushmore optimization should work in VFP OLE DB provider the same way as in VFP itself but it can only use structural indexes. The WHERE condition in your example should be optimizible in VFP and in the provider.
--sb--