>Jim,
>
>That's a good example of using unique indexes, but wouldn't SELECT DISTINCE State FROM customer be faster and easier in most cases?
>
If the select is not rushmore otpimizable then no the index on techique would be faster. However, just because it is a good example of where a unique index could be helpful, I would use the SELECT approach because it is more universally applicable.