Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

Explain features and concepts of analysis services?

0 Answers  

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

What is user stored procedure & it purpose?

4 Answers   Wipro,

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

What is the recovery model?

0 Answers  

can you any body tell me which service pack is installed in the sql server?

3 Answers  

event classes in sql server

2 Answers   Accenture, AFE,

Why do we use stored procedures in sql server?

0 Answers  

What is a join and their types?

2 Answers   Challenger Financial,

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

What are page splits? : SQL Server Architecture

0 Answers  

For more SQL Server Interview Questions Click Here
Categories