Index and statistics

Giganews Newsgroups
Subject: Index and statistics
Posted by:  simon (zupan.n…@gmail.com)
Date: Mon, 27 Dec 2010

I have SQL2008 with auto update statistics and auto create statistics
and auto update statistics asynchronously  set to ON. This setting is
suggested for general case.
Anyway I have maintaince plan which rebiulds all indexes and
statistics with full table scan every night, when nobody uses the
database.

Is this good practice or is some disantvantage with this behaviour?
I guess that index rebuild is not necessary(only if index is
defragmented), but if there is no damage than to be on save side I
would leave it to rebuild every night.

I noticed also that all indexes are created with
STATISTICS_NORECOMPUTE  = OFF. I guess that this is by default.
Should I change it to ON?

What is the best practice with this?

br,
Simon

Replies