Adding Indexes

• JuanBob

  SSCertifiable

  Points: 5059

  More actions

  March 31, 2006 at 9:51 am

  #116852

  Just a quick question about adding indexes.  Is it necessary to create indexes after hours or during low usage?  My table is only 5 fields but there are hundreds being added each minute.  This is much higher than expected so I would like to modify or add an index. 

  Thanks!

• mimorr

  SSCarpal Tunnel

  Points: 4850

  More actions

  March 31, 2006 at 1:56 pm

  #630233

  If you are using SQL 7 or SQL 2000, you will need to create the index when no one will need to access the table.

  If there will be hundreds of rows added each minute, be sure to read up on fillfactor in BOL to help keep index fragmentation to a minimum.

  
  
  Michelle