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
- 21795 Views
- I also Faced
- E-Mail Answers
Answer Posted / jai
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
List the different types of joins?
What command is used to rename the database?
How you can get a list of all the table constraints in a database? : Sql server administration
How to access the inserted record of an event?
Explain the difference between primary keys and foreign keys?
What is the full form of dql?
What is an entity-relationship diagram (erd)?
Please illustrate physical database architecture? : SQL Server Architecture
Tell me what is difference between clustered and non clustered index?
How can we check the sql server version?
How to search for a string in all stored procedure in sql server?
What happens if you insert a duplicate key for the primary key column in ms sql server?
How to store and query spatial data?
What is ems sql management studio? : sql server management studio
How to convert binary strings into integers in ms sql server?
