1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / abcd


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 system function to get the current user's user id?

3 Answers   TCS,

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

Define inner join in sql server joins?

0 Answers  

What are sql dirty pages?

0 Answers  

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  




can a database be shrunk with users active? : Sql server administration

0 Answers  

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

What is the return type of executeupdate ()?

0 Answers  

How can you control the amount of free space in your index pages?

0 Answers  

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

How to find 6th highest salary from Employee table ?

10 Answers  

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories