>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,
Unique indexes should only be used as temporary indexes. For example, assume you ahve a customer table with 50,000 records in it and you want a list of states that you have custoemrs in, you can;
USE Customer
INDEX ON State TAG Temp UNIQUE
* Print your states listing
DELETE TAG Temp