>If one has a primary index on a key field that sets a flag on !DELETED(), does one need a second index on the same expression w/o the filter for full Rushmore optimization?
>
>TIA
Nancy,
There was a lengthy discussion about this recently on the newsgroups. According to VFP help, filtered primary keys are fully optimizable, while regular and candidate indexes are not. I think is has to do with how the index is created (ALTER TABLE vs INDEX ON)
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer