Administration

• subbarayudu.net 37258

  Mr or Mrs. 500

  Points: 540

  More actions

  March 10, 2010 at 6:28 am

  #137593

  Hi Every Body,

  Please can you share cluster and non-cluster index details with example

  Example: Table A having 1000 Records. This table having the Cluster index.So how to store the data into this table.

  Table B having 1000 records, Non-cluster index, how to the data store.

  Thanks

  Subbarayudu

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 10, 2010 at 6:41 am

  #1131324

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

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

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

  http://msdn.microsoft.com/en-us/library/ms180978.aspx

  http://sqlinthewild.co.za/index.php/category/sql-server/indexes/

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  March 10, 2010 at 6:52 am

  #1131340

  "how to store" has nothing to do with the indexing. Perhaps you should read a few links Gail posted to understand what in index is.