Why can there be only one clustered index and not more than one?
- 1 Answers
- 1077 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vipul Agrawal
In SQL Server, a table can have only one clustered index because a clustered index determines the physical order of data in the table. When multiple clustered indexes are created on a table, it leads to fragmentation and impacts performance. By allowing only one clustered index per table, SQL Server ensures that data is organized efficiently.n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we do dml on views?
Explain “row_number()” in sql server with an example?
List out the different types of locks available in sql server?
what is the difference between openrowset and openquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What kind of problems occurs if we do not implement proper locking strategy?
Why we use the openxml clause?
What is a view in sql?
How do I start sql server 2017?
How do I create a trace in sql server?
What are the different SQL Server Versions you have worked on?
What are different types of constraints?
What is clustered index
Can we shrink data file in sql server?
How to remove duplicate rows from table except one?
