Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7486 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 the xml datatype?
What is the sql case statement used for? Explain with an example?
Where are sql server usernames and passwords stored in the sql server?
What is sqlcmd?
Benefits of Stored Procedures?
What Is Rdbms?
What is the importance of a recovery model?
What are different types of schemas?
Explain having clause and where clause?
What is a group function explain with an example?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is the maximum size of a row in sql server?
What is difference between oltp and olap?
