>You are right about me being wrong -- I experimented, and FoxPro is clearly using Rushmore to SELECT for SQL queries.
Some indices help in making queries or views faster, some make them slower. See FAQ#8109.
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)