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
- 21838 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
What is exporting and importing utility?
When does a workload on SQL Azure get throttled?
How we can refresh the view?
State the difference between union and union all?
What is SQL Azure Data sync?
How to create user defined functions with parameters?
What is #temp and @table variable in SQL server?
Explain cross join or cartesian product in sql?
How much memory that we are using in Logshipping Concept?
How to backup SQL Server Reporting Services ?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is difference between count (*) and count 1?
What is a ddl statement?
What is resource db in sql server?
Why should one not prefix user stored procedures with ‘sp_’?
