SQL Server Should I reindex after Truncate Table? 1

[mit99mh]

I've inherited a DTS package that populates a table with close to 1 million rows. The table has a clustered index and several non-clustered indexes. The DTS package issues a truncate table comand and then data is copied into the table with a SELECT. Should I then re-index or as the data is copied in are the indexes updated?

Any help much appreciated.

 

[ptheriault]

No, just update statistics.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

The indexes will be updates as the new data is written.

As Paul said doing an update stats would be a good idea after the data load is complete before you start using the table for anything.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com