From: "Alexandre Benson Smith" <iblist@...>

>
> Set statistics will recompute the index selectivity.
>
> Alter index INDEX_NAME INACTIVE;
> Alter index INDEX_NAME ACTIVE;
>
> Will rebuild the index.
>
> Note that you cannot make an index created by a constraint (PK, FK,
> Unique) inactive.

Speaking of these, are these indexes kept up with in any way so that
statistics are usually accurate on them? I am wanting to create a script
that would run once a week to reset statistics on indexes and I have been
wondering if I need to do the same to PKs, etc. by issuing the set
statistics command.

Woody (TMW)