General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thank you Sergey!
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only