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 master database? : SQL Server Architecture

0 Answers  


How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  


what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,


Explain left outer join and right outer join?

0 Answers  


Define cursor locking

0 Answers  






What do you mean by an execution plan?

0 Answers  


How do you size a resultset?

0 Answers  


if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,


How to integrate the ssrs reports in application?

0 Answers  


How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  


What is primary key index?

0 Answers  


What are the types of model in sql server and explain

2 Answers   TCS,


Categories