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

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

How would you use user_constraints table in DB?

0 Answers   Wipro,




I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

What is triggers and its types?

0 Answers  

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

Does index slows down insert statements?

0 Answers  

What to check if a User database is locked?

0 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories