How Nonclustered index uses Clustered index

• chaithu559

  SSCommitted

  Points: 1574

  More actions

  June 11, 2012 at 6:35 am

  #270847

  Hi Experts,

  I have read in many articles . It says that If a table has clustered index and nonclustered index, it is said that "nonclustered index internally uses clustered index ." I am worried about the above statement. Please help me in understanding how this happens .

  Thanks

  Chaithanya M

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 11, 2012 at 6:40 am

  #1499278

  Take a read through these.

  http://www.sqlservercentral.com/articles/Indexing/68439/

  http://www.sqlservercentral.com/articles/Indexing/68563/

  http://www.sqlservercentral.com/articles/Indexing/68636/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass