Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8998 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
How to add additional conditions in SQL?
What are the different kinds of ssrs reports?
How do users use Report Builder with SQL Server data sources?
What is single-user mode?
How do you check sql server is up and running?
What is parameterized reports in ssrs ?
Why would you call update statistics?
What are the types of normalization?
what is isolation level at dead lock?
What structure can you implement for the database to speed up table reads?
What is a scheduled job or what is a scheduled task?
Differentiate between delete and truncate.
What is a trigger? Why we need it?
What is importing utility?
How to optimize stored procedure optimization?
