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
- 21538 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
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is service broker?
What is the purpose of data source?
What is the process of indexing?
How fixed length strings are truncated and padded?
Define Business Edition in SQL Azure?
What is correlated subquery in sql server?
How to execute function in stored procedure sql server?
What are the benefits of filtered indexes?
How to see existing views in ms sql server?
What purpose does the model database server?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Explain the difference between primary keys and foreign keys?
