>
> Quite so. SET STATISTICS is not the same as rebuilding the indexes.
> ALTER INDEX <name> INACTIVE followed by ALTER INDEX <name> ACTIVE

is.

>

As long as everything works, is there ever any need for rebuilding an
index ?

I uses SET STATISTICS on half the tables because there are a lot of
insert, updates and deletes.

The other half will 99,9 % of the time be INSERT (or updates, but the
never updates the fields that are indeksed).

So I should be fine, using a SET STATISTICS ?

Thank you very much.

Michael