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

What is meant by referential integrity?

0 Answers   Blue Star,

How to transfer a table from one schema to another?

0 Answers   MCN Solutions,

What are different types of subquery?

0 Answers  

What are views in ms sql server?

0 Answers  

Can we do dml on views?

0 Answers  

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

What is resource db in sql server?

0 Answers  

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

What is a synonym for manipulation?

0 Answers  

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

What is reference section?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories