Hi everyone,
we know that creating indexes are increasing the searching and query performances.
Depend on that I have two questions;
1- In SQL Server there is two options, As you can see in attachment I put,
After we set the unique property of a field "Yes", from the type, are we have two options which are "Unique Key" and "index".
Which one should be choosen to increase the performance? Is there any differences?
Because I did not understand, why there is separate option to choose Unique Key, after we have already set "Yes" for unique property?