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
- 22049 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
Why de-normalization required?
Do you know what guidelines should be followed to help minimize deadlocks?
What do we need queues in sql service broker?
What are the differences between union, intersect, and minus operators?
What is difference between count (*) and count 1?
Define right outer join?
Explain the categories of stored procedure?
Explain forward - only cursors?
What are the types of table?
What are cursors in ms sql server?
How to access the deleted record of an event?
Explain what you mean by 3 tier architecture.
What is the use of toad or sqldbx.?
What is store procedure?
How can I change procedure name in sql server?
