<snipped> > > What if I created 6 different indexes so I can have all the combinations > of client_id, status, and plan? > > So if the user wants all the accounts where status='100', > client='10006' and plan= '123' Would there be an optimized way of setting > a filter? Creating a local index on the fly? > > Again, if I were writing this program from scratch, I would use SQL select > statements to create a subset of the database, but I don't really have an > option to re-write the program at this time. > <snipped>
AFAIK VFP has always (well, since CDX became available) has had the ability to use an index if it needs to. If it has an index and can be useful to the query/filter/whatever then it gets put to use. You don't HAVE to create a CLIENTID+STATUS+PLAN compound index if you don't want to. Having one each on the three fields should do it. Or am I full of sh!t on this? <g> Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. _______________________________________________ Post Messages to: ProFox@leafe.com 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/69f310c05dd83c48a84ba3769ce1ecf806251...@tntriexevs02.triadhospitals.net ** 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.
