Interested to Buy Any Domain ? << Click Here >> for more details...
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 22051 Views
- I also Faced
- E-Mail Answers
Answer Posted / samrat sen
Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.
| Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
What is the template in sql?
how would you store your query in an SSRS report or a Database server?
What is a livelock?
What is use of except clause? How it differs from not in clause?
List out the differences between global and local temp tables in sql server?
How can we improve performance by using SQL Server profiler?
what is the main function of a query parameter?
What is the use of toad or sqldbx.?
How do I shrink an ldf file?
What is the dbcc command and why is it used?
Can we use trigger new in before insert?
Do you know what is fill factor and pad index?
What are the different normalization forms?
What are the restrictions while creating batches in sql server?
What is public role in sql server?
