WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 20572 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
What is join query?
Explain stored procedure?
What do we need queues in sql service broker?
What is indexed view?
How to find index size for each index on table?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What are the steps you can take to avoid “deadlocks”?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Describe in brief sql server monitoring ways.
Can sql servers linked to other servers?
How can you start sql server in different modes?
What is a data collection table?
How can I add Reporting Services reports to my application?
Can you tell me about the concept of ER diagrams?
