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
- 21535 Views
- I also Faced
- E-Mail Answers
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 is difference between line feed ( ) and carriage return ( )?
What are various limitations of the views?
What is a deadlock and what is a live lock?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Tell me what is fill factor?
What is an entity-relationship diagram (erd)?
What is cursors? And what are the different types of cursor?
What is query and its types?
Do you know what is rank function?
what is normalization? : Sql server database administration
How do you clear a log file?
Does partitioning ssd reduce performance?
How to generate create procedure script on an existing stored procedure?
How to create database with physical files specified in ms sql server?
What are drilldown reports?
