diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 5115 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / indraneelandhavarapu
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to delete a database in ms sql server?
Where cross join is used?
What is the difference between executequery () and executeupdate ()?
How to create new databases with "create database" statements?
Explain transaction server implicit?
What’s the distinction between dropping a info and taking a info offline?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is the difference between set and select?
What is a collation?
What is the osql utility?
How to create a testing table with test data in ms sql server?
what are the critical issues you have resloved in your company
Explain powershell included in sql server 2008?
List some of the rules that apply to creating and using a ‘view’
What is data modification?
