John,
That's true, but a unique index is not the same as a candidate index. It doesn't keep you from adding duplicate values, it just ensures that only one record will appear in the index for each distinct key value.
>Rock ---
>
>Yes, it's still needed. If you are creating a standalone index (IDX), Candidate is not an option.
>
>
>>Does anyone know of a valid reason for using the Unique index type? If there are duplicates, you should use Reqular and if they are truly key fields then Primary or Candidate should be used. (IMNSHO)
>>
>>Is it there for backward compatibility? There's nothing I've found to that effect.
>>
>>Thanks,
>>Rock