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

diffrence between function and procedure

5 Answers   Wipro,

whats the maximum size of view state??

0 Answers  

Define Check points and End Points?

1 Answers  

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

Explain the collation?

0 Answers  

How do I setup a local sql server database?

0 Answers  

Explain what is scheduled job and how to create it?

0 Answers  

What is replication and database mirroring?

0 Answers  

Can you type more than one query in the query editor screen at the same time?

0 Answers  

explain query execution plan

1 Answers  

How can we check the sql server version?

0 Answers  

Explain steps of normalization?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories