>I removed the deleted()s. Performance is a lot better. Thanks. Any other ideas of increasing performance?
The problem with deleted() is that it selects many, many, records. This is bad, because of the way R.Optimization works. Delete any other index that selects many records, like INDEX ON GENDER.
I wrote an article, available in the UT FAQ.
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)