>Renoir,
>
>>I actually started using a unique integer table-driven primary key for my tables not too long ago (thanks Vlad!). What's the best way to ensure uniqueness in my candidate keys?
>
>A filtered candidate index (INDEX ON MyCandidate TAG MyCandidate FOR !DELETED() CANDIDATE)
>
>Walter,
Quite important, this part. I completely forgot it. IF you use surrogate keys (auto-incremented), a filter is irrelevant. But for candidate keys, the filter has to be included.
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)