Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?



Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they intern..

Answer / anand vanam


•In clustered Index leaf node contains the actual data pages
where as in Non clustered index leaf node contains index
pages.

•You can have only one clustered index per table but you can
have 249 Non clustered indexes per table as per SQL 2005
(999 in SQL 2008)

•The row locator in clustered index is the Clustered Index
Key where as in Non clustered index row locator is a pointer
to the row.

Is This Answer Correct ?    10 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,


How to find the last update record in SQL Server?

4 Answers  


Explain for xml explicit mode?

0 Answers  


Which institute is best for SQL Server 2005 Training?

6 Answers  


What is bcnf normalization form?

0 Answers  






what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  


What is a synonym for manipulation?

0 Answers  


What is a data source file?

0 Answers  


What is a schema in ms sql server 2005?

0 Answers  


How to turn off warning messages during php execution?

0 Answers  


Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,


what is the cursor life span?

5 Answers   Evalueserve, HG,


Categories