Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions What is the difference between clustered and nonclustered indexes

SQL Server indexes

 View(s): 14319

What is the difference between clustered and nonclustered indexes?

Answer 1)

  1. A clustered index is a special type of index that reorders the way records in the table are physically stored. 
  2. Therefore table can have only one clustered index and this is usually made on the primary key. The leaf nodes of a clustered index contain the data pages.
  1. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
  2. There can be as many as 249 nonclustered index per table
  Asked in:  LiquidHub   Expertise Level:  Intermediate
  Last updated on Saturday, 27 November 2010
4/5 stars (9 vote(s))

Register Login Ask Us Write to Us Help