>I have a question on indexing performance, a .NOT.DELETED filtered index vs a non-filtered index, which one gets higher performance? And is there any subsequent impact?
>TIA
An index with a filter will not be used for Rushmore Optimization. Therefore, these indices are normally avoided.
However, a filter may be required for a primary or candidate index - or else, VFP will protest when you try to add an entry that matches a deleted record.
In this case, for maximum performance, you may want to have TWO indices on the primary or candidate key field - one with a filter, one without. The filtered index will be the PK or CK.
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)