MS SQL Data Warehousing - Indexes vs Statistics

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Indexes vs Statistics

Magnus Österberg

2006-03-26, 11:23 am

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

Sponsored Links