WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 20569 Views
- I also Faced
- E-Mail Answers
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
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Ways to improve the performance of a SQL Azure Database?
1 01 101 01010
How to get nth highest salary from employee table.
How to verify the port number of the sql server?
What is named query? : sql server analysis services, ssas
What are the advantages of using stored procedures in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How you can minimize the deadlock situation?
Differentiate between mongodb vs. Sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to delete duplicate rows from table except one?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
When I run the sql server 2000 setup, it just hangs. What do I do?
List few advantages of stored procedure.
