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
- 21791 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhijit
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 ? | 5 Yes | 1 No |
Post New Answer View All Answers
Which data type columns are the best candidates for full-text indexing?
What are alternate keys?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Define ACID properties in a Database?
How to list all objects in a given schema?
What is the difference between a view and a stored procedure?
What happens if you add a new index to large table?
Is there any difference between the primary key and unique key?
What is difference between group by and having?
What is bcnf normalization form?
How to view existing indexes on an given table using sys.indexes?
What is difference between inner join and full join?
How to get all stored procedures in sql server?
What is the benefit of normalization?
List some advantages and disadvantages of stored procedure?
