Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8995 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
Clustered index is a special type of index that reorders
the way in which the data is pysically stored in table.A
table can have just 1 clustered index.leaf nodes of a
clustered index contains the datapages.
Non clusterd index is also a special type of index in which
the logical order of the index doesnt match physical stored
rows on the disk.A table can have multiple indexes probably
(16).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is failover clustering overview?
What is exclusive locks?
How to round a numeric value to a specific precision?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Describe the functionalities that views support.
Do you know what is a linked server in sql server?
How to backup encryption key ?
Mention the different types of replication in sql server.
How to find table changes in sql server?
What are the rendering extensions of ssrs?
What is the filtered index?
What is the use of set nocount on/off statement?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are filegroups in sql server?
Suggest a method of joining two tables.
