About this Article:
We all know that Visual FoxPro is extremely fast, especially with small volumes of data. However, as the amount of data grows larger it is critical that your tables are properly indexed in order to take advantage of Visual FoxPro's optimization capabilities. This, of course, raises the question of exactly which columns you should be indexing, and whether you should use an index on DELETED(). This month Andy and Marcia are discussing some thorny issues that only surfaced in an application when the tables being used became very large.