My understanding is the left side of the WHERE or FOR clause is what has to match the index expression in order for Rushmore to kick in. Because your index uses UPPER, your search memvar should also be UPPERed when you store the search value or UPPERed in the SQL itself. But not for optimization but for getting the results you want. And as that wise man Ted Roche likes to say, test, test, test...
-- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Wednesday, February 09, 2011 2:21 PM To: [email protected] Subject: Re: VFP9 - Speed Hello folk This has been really helpful Please may I indulge you once more Should the select be: Select * From winhst Where UPPER(serno)=trcask Order By invnum Into Table (myfile) or Select * From winhst Where trcask=UPPER(serno) Order By invnum Into Table (myfile) _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD0441922281A03@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.
