10
Uniqueness and Performance
Arguments FOR Declaring Uniqueness
It's typically better to provide more information to the optimizer rather than less. If you know that an index is unique, it's best to declare it that way. This can help the optimizer, as well as providing clarity about your data to ...