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

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,


Difference between writing SQL query and stored procedure ?

15 Answers   TCS, Infosys, Cognizant, Veritas,


What is a Join in SQL Server?

3 Answers  


what is curser.

9 Answers  


Which system tables contain information on privileges granted and privileges obtained

1 Answers  






How cand Optimize SQL Server Stored Procedures

1 Answers  


What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,


how to connect sybase to sql server 2005?.

1 Answers   ABC,


i need some interview questions on sql server developer plz any onee send some links.

2 Answers  


What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,


What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,


What value could be assigned to Varchar Type?

3 Answers  






Categories