WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
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
Do you know sql server 2008 backup compression?
How to copy data from one table to another table?
How to create stored procedures with parameters in ms sql server?
What is the default schema of your login session in ms sql server?
What are the new features of sql server 2008 r2 reporting service?
How can you find out how many rows returned in a cursor?
How do I view a stored procedure in sql server query?
What function does a database engine serve in the sql server?
What do you mean by a dependent functionality in a build?
Explain collation?
What is explicit cursors?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Do you know what is sql service broker?
How to insert multiple rows with one insert statement in ms sql server?