Indexes

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  November 5, 2004 at 12:39 pm

  #84764

  Hey gurus,

  As some of you know I'm novice when it comes to SQL Administration.  My company is going to be putting up and new website , along with a new database schema. 

  Question:  Is there a general rule of thumb on what to index and what not to?  How do you know what would make a good index?

  Any help would be much appreciated.

  Shane

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 5, 2004 at 1:52 pm

  #529162

  Okay, let's start with some reading material.

  First rule of thumb: Read BOL

  Second: If you can get hand on "Inside SQL Server 2000", read it, too.

  Third:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;814324

  http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqlpro04/html/sp04f9.asp

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;820209

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 5, 2004 at 1:56 pm

  #529163

  hehe, before you get bored:

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/indexedviews1.asp

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]