Index Out of Synch

• Starhura

  SSC Veteran

  Points: 294

  More actions

  December 9, 2003 at 6:27 am

  #107022

  

  I've been working w/ SQL for the last two months and don't know what I would like but I do a lot of reading. What would cause an index table to get out of synch?

• Keith Henry

  Hall of Fame

  Points: 3759

  More actions

  December 9, 2003 at 9:04 am

  #485353

  What do you mean? The statistics for an index could become out of sync if you did a large insert, update or delete in certain conditions. What problem are you getting?

  Keith Henry

  DBA/Developer/BI Manager

  
  
  
  Keith Henry
  

  ---

  
  According to everyone I know I "do something with computers?" for a living, so there you go.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 9, 2003 at 1:12 pm

  #485410

  I think this is the wrong category for this thread. What about using the existing other thread on this topic?

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  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

  December 9, 2003 at 1:15 pm

  #485412

  Sorry, might work better with providing this link

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19009&FORUM_ID=9&CAT_ID=1&Topic_Title=SQL+Index+Tables+Out+Of+Sych+%2D+How%3F&Forum_Title=General

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

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