WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 20570 Views
- I also Faced
- E-Mail Answers
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
What is the Control Flow in SSIS
What are relationships and mention different types of relationships in the dbms
Why main is user defined function?
what are constraints? Explain different types of constraints? : Sql server database administration
Why do we use functions?
What is normalization? Describe its different types.
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How many types of database relationship in sql server?
Can we shrink data file in sql server?
What is the use of stored procedure?
What is row_number()?
What authentication modes does sql server support?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is a functions and types in sql server?
