Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7468 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / vijaya
In Clustered Index, the data is physically sorted.
only one Clustered Index is created per table.
The data is stored in heap level of the B-tree.
In non-clustered Index, the physical order of the rows is
not same as the order of index.
there can be upto 249 non-clustered index per table.
the data is present in the random order but the logical
ordering is specified by the index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What stored by the msdb? : sql server database administration
What is the difference between for xml raw and for xml auto?
How does the report manager work in SSRS?
Explain system scalar functions?
How to delete multiple rows with one delete statement in ms sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What are the database roles? : sql server security
How can you check the level of fragmentation on a table?
What is the importance of three tier architecture?
How to apply filtering criteria at group level with the having clause in ms sql server?
What does the on update no action do?
Do you know the capabilities of cursors?
What is lookup override?
What are the differences between char and nchar in ms sql server?
What is dbcc?
