>Maybe I have understood wrong - I thought it would increase performance if I have a big table with multiple logical fields when I want to select all records where 6 of the logical fields are true? Is this not correct or do I not gain anything in this senario with indexes?
I think you lose performance, especially over a network. Read my FAQ #8109, and do some speed tests.
Basically, VFP has to get index keys for all the records that match the key expression (.T., or .F.). This may take a long time - but report "Full Rushmore Optimization".
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)