What is a unique index?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a unique index?
Rating:
A unique index specifies that the value of a column (or columns), upon which the index is based, must be unique. If a user creates a unique index containing several columns, the unique index ensures that the combination of all values contained in the index is unique. Both clustered and nonclustered indexes can be unique provided that the data in the column is unique. Hence, both a unique clustered index and multiple unique nonclustered indexes on the same table can be created. When a primary key or unique constraint is created on the specified columns, a unique index is automatically created.
Rating:
Was this information helpful?
Other articles
- What is SQL Server Profiler?
- What is Disk Management?
- What is a full backup?
- What is SQL Server service?
- What is HAVING clause?