KS,

When you create new indexes they are built at that time, with no further
steps needed. Also, a new index has up-to-date statistics, so you should
not need to update them.

However, changes to data can cause the cached statistics on the row counts
per key ranges to age, so if an index has been around for a while, it may be
helpful to do an UPDATE STATISTICS or sp_updatestats. Also, you can defrag
the indexes using DBCC REINDEX or DBCC INDEXDEFRAG (or in SQL Server 2005,
ALTER INDEX ... REBUILD).

But, of course, the main issue is to create indexes that are useful to your
queries.

RLF

"KS soerensen (AT) os (DOT) dk>" <keld.<SLET_DETTE> wrote