>Hi,
> I am using SQL to query records from a big table. VFP need 4 secs to retrieve 4 records out of 20,000 records with FULL OPTIMIZED under 100 BASET Network. Is it acceptable? Any way to impove?
>
>Thank you
Perhaps you should delete some index. One index too many can make some queries very slow, because if an index exists, Rushmore Optimization will use it! The only condition is that the filter expression matches the index, whether using the index makes sense or not.
The key question for each index is: how many records match a specific value? If the answer is "many", the index hinders you more than it helps. Specifically, you should
never have an index on "deleted()". Of course, some indices are required for RI, but these usually don't return too many records for a given key value.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)