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 are the character string functions supported by sql server 2005?

0 Answers  

What is DAC? what is the use of it?

1 Answers   Wipro,

What is ms sql server reporting services?

0 Answers  

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

Explain aggregate functions?

0 Answers  

What are the steps you must follow to hide sql server instances?

0 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

What is the openxml statement in sql server?

0 Answers  

What the class forname () does?

0 Answers  

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

What is standby servers? Explain types of standby servers.

0 Answers  

How to list all user names in a database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories