Defragging a DB

• EjSQLme

  SSCrazy

  Points: 2172

  More actions

  April 6, 2011 at 11:31 am

  #249099

  HI,

  Do you have to have indexes to do a defrag and stat update on a DB or just having a primary key enough?

  Thanks,

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  April 6, 2011 at 12:38 pm

  #1308212

  Primary keys are indexed, so yes, defrag will help. If all you have are primary keys, I'm not sure if update stats will do much good.

  ---

  Have Fun!
  Ronzo