Do I need to reindex the table after I truncate it and perform bulk insert

• Lanny Irwan

  Ten Centuries

  Points: 1020

  More actions

  October 31, 2007 at 3:46 am

  #183495

  Hi,

  Is it necessary to reindex the table after I truncate the table and perform bulk insert?

  Cheers

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  November 2, 2007 at 12:08 am

  #747623

  Yes you need to do a reindex of the table after a bulk insert.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com