How updating index is done?

• titifefe

  Grasshopper

  Points: 19

  More actions

  November 7, 2008 at 9:07 am

  #124834

  Hello,

  i am working on SQLServer2000 and need to know how the update of the index is done:

  I create an empty table with a non clustered index,

  when i insert hundreds of rows, do my index is updated ?

  do i have to update it with a specific command?

  thanks

• Jp

  Default port

  Points: 1419

  More actions

  November 7, 2008 at 9:27 am

  #895644

  Indexes are attached with Tables and as a result Indexes are updated along with the table updates.

  Hope this helps.

  -Jp

• titifefe

  Grasshopper

  Points: 19

  More actions

  November 7, 2008 at 9:40 am

  #895660

  thanks JP,

  Is there any documentation on the subject?

• SQLBOT

  SSCrazy Eights

  Points: 8014

  More actions

  November 7, 2008 at 10:08 am

  #895683

  SQL Books online is a great tool you should consider using.

  http://msdn.microsoft.com/en-us/library/aa174541(SQL.80).aspx

  This is a SQL 2005 forum, btw.

  ~BOT

  Craig Outcalt

  ---

  
  Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
  My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258