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
- 21840 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 Use A Stored Procedure To Provide Data To An Ssrs Report?
Explain transaction server consistency?
What is exporting and importing utility?
What is the difference between for trigger and after trigger?
Tell me what is difference between view and materialized view?
How to get a list of columns in a view using the "sp_help" stored procedure?
How do I find the default sql server instance?
Why do we partition data?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How to rename an existing column with sql server management studio?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How is sql used in sql server?
Explain user defined views?
How many full-text indexes can a table have?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
