WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / honnur swamy
A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.
Is This Answer Correct ? | 33 Yes | 3 No |
Post New Answer View All Answers
What does sql server mean?
What is fill factor and pad index?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are built in functions?
How to access the deleted record of an event?
Explain the dbcc pintable command when would you use it?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
How do I create an extended event in sql server?
What are date and time data types in ms sql server?
Can you tell me about the concept of ER diagrams?
What is a non-clustered index?
What is a DBMS, query, SQL?
Explain multiserver query
Can you please differentiate between a primary key and a unique key?
Is INSTEAD OF trigger directly applicable to Table ?