Sql server - What is Unique Index?

What is Unique Index?

- Unique index is the index that is applied to any column of a unique value.
- A unique index can also be applied to a group of columns.
- It guarantees that the index key contains no duplicate values.
- It ensures that the data integrity of the defined columns.
- It provides additional information that helps to query optimizer to produce more efficient execution plans.

Syntax:
CREATE UNIQUE INDEX index_name
ON table_name (column_name);
Sql server - Difference between clustered and non-clustered index
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data........
Sql server - Explain the 'Fillfactor' concept in Indexes
The fill factor option is provided for smoothening index data storage and performance........
Sql server - How do you maintain a fill factor in existing indexes?
Usually the data keeps getting added, deleted, or updated in the table due to which the fill factor is implemented during the index creation itself........
Post your comment
Discussion Board
Test, just a test
Hello. And Bye.
XRumerTest 01-24-2018

Related Content

Follow us

▲