Clustered and Non Clustered

• Saranya20

  Grasshopper

  Points: 11

  More actions

  May 12, 2011 at 7:07 am

  #389511

  Hi SQL guys,

  I still didnt got correct explanation for Clustered and Non Clustered. anyone?

  Thank you,

  Saranya.

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  May 12, 2011 at 7:10 am

  #1323638

  http://lmgtfy.com/?q=clustered+index+vs+nonclustered+index

  Adi

  --------------------------------------------------------------
  To know how to ask questions and increase the chances of getting asnwers:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  May 12, 2011 at 8:13 am

  #1323687

  Clustered and nonclustered indexes? (as opposed to clustered instances)

  If so

  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