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
- 21798 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
How do I view a stored procedure in sql server query?
Characterize join and name diverse sorts of joins?
Define Business Edition in SQL Azure?
Can you name some of the dml commands in sql?
What is normalization process?
What is side by side migration in sql server?
Can we update data in a view?
What is master database? : SQL Server Architecture
How to use “drop” keyword in sql server and give an example?
Mention the differences between substr and charindex in sql server.
What are the types of database recovery models?
What are truncate options available in sql server? : sql server database administration
What is a covering index?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
what are triggers? : Sql server database administration
