Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 9021 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 check constraint in sql server?
Do you know what are pages and extents? : SQL Server Architecture
How except clause is differs from not in clause?
What are the types of sql server?
What are constraints?
What is built-in function?
What are tables in sql server?
How you can get a list of all the table constraints in a database?
how would you store your query in an SSRS report or a Database server?
What are different types of raid levels?
How to link tables in sql server?
What is standby servers? Explain types of standby servers.
What do you understand by the denormalisation?
What are the two authentication modes in sql server?
Which table keeps the locking information?
