WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / shailesh arban
Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How to stop a loop early with break statements in ms sql server?
What is the difference between for xml raw and for xml auto?
How to select some specific rows from a table in ms sql server?
Can two tables share a primary key?
What do you understand by the denormalisation?
What are magic tables in sql server?
Is sql server implemented as a service or an application? : Sql server database administration
What are temporal tables in sql server 2016?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is the security principal at the database level that represents your session?
What are the components of dbms?
What are the drawbacks of reporting in ssrs?
What is updatable resultset?
What is user defined datatypes and when you should go for them?
How do you clear a log file?