Basic rule of Rushmore: the left side of your expression must exactly match an index for the query to be optimized.
Don't know about any limitation to Rushmore in the VFP OLEDB driver. A brief stroll through the help does not mention Rushmore at all but implies that the OLE DB provider has all the features of the ODBC driver along with support for more VFP specific functionality including calling stored procs and DBC events. rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Tuesday, November 10, 2009 2:35 PM To: [email protected] Subject: Re: VFP9SP1 free tables accessed over OLE-DB from DotNet app...they'll use indexes when possible, right? > > I seem to remember that if you have an index on field1+field2 then it > will not use the index if you do: > select * from table where field1='hi' and field2='ho' > > Instead you need to use: > select * from table where field1+field2='hiho' ----------------------- That may be true with a VFP index. That you have to combine them in a string instead of Pkey(int) + Fkey(int) + Datetime + ??? _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd044065cb0b...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
