One help please

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  May 5, 2009 at 6:34 am

  #220826

  Hi ,

  Any one of you have any doc or ebooks which explains the exact working of Index , if so can I get it ....

  Regards,

  MC

  Thanks & Regards,
  MC

• noeld

  SSC Guru

  Points: 96590

  More actions

  May 5, 2009 at 7:51 am

  #988809

  Google is your friend:

  http://www.sqlteam.com/article/sql-server-indexes-the-basics

  Here is another from Brent Ozar:

  http://www.brentozar.com/archive/2006/04/sql-server-training-for-developers-primary-keys-indexes/[/url]

  
  * Noel

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  May 5, 2009 at 10:17 am

  #989009

  Hi, thanks for the reply .

  Regards,

  Mithun C

  Thanks & Regards,
  MC

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 5, 2009 at 10:26 am

  #989020

  There's some stuff here that may help, but it assumes you know the basics.

  http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

  http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

  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

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  May 5, 2009 at 10:55 am

  #989040

  Hi thanks for the reply,

  I would like to know something like , how search is becoming faster when we create an index on that.

  Thanks,

  M.C

  Thanks & Regards,
  MC

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 5, 2009 at 11:07 am

  #989053

  Searches are faster on indexed columns because SQL can quickly find the matching records rather than having to read through the entire table.

  Imagine the telephone directory. Because it's in order of surname, you can easily find someone without having to read every entry.

  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

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  May 5, 2009 at 11:19 am

  #989059

  Ok.. thanks

  Regards,

  M.C

  Thanks & Regards,
  MC