sql server data warehouse: Hi!

A beginner's question...I would look up the answer myself if I had the time,
I'm in a bit of a hurryy...

Indexes vs Statistics:

Does running sp_updatestats mean that all indexes in my database is updated?
If no, then how do I do in order to update the indexes? I know CREATE INDEX
and sp_updatestats, but how is indexes updated or rebuilt??

Magnus

Hi Magnus,

I don't think sp_updatestats rebuilds/updates indexes. All it does is
to... collect stats.

But if you want to be sure to rebuild all indexes, try DBCC DBREINDEX.
Note that DBCC DBREINDEX only works for a single table, so you will need
to work around information_schema.tables to update every indexes or your
database.

Hope it helps,

Franck

Le Sun, 26 Mar 2006 19:31:11 +0300, Magnus Österberg a
écrit :

[quoted text, click to view]