Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7450 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
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What do you understand by integration services in sql server?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What do you mean by an execution plan? Why is it used? How would you view it?
What is resource governor in sql server?
What are parameterized reports?
How use inner join in sql server?
What is the current limitation of the size of SQL Azure DB?
How to delete database objects with "drop" statements in ms sql server?
How to identify current user in ssrs report?
What are the different types of replication you can set up in sql server?
What is the difference between executequery () and executeupdate ()?
how to invoke a trigger on demand? : Sql server database administration
Comment,Datatypes are unlimited
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
