Subject Re: Updating index statistics
Author lacakus
Can I achieve "updating statistics" by :
alter index <indexname> inactive;
alter index <indexname> active;

In docs says "Reactivating a deactivated index rebuilds and rebalances
an index."

set statistics index <indexname>;
In docs says "SET STATISTICS enables the selectivity of an index to be
recomputed"

I ma not sure if alter index also recomputes selectivity informations
or only rebuild index tree ?

-Laco.

P.S. according to discussion in Firebird-devel list it would be nice
fature have "auto update statistics" like MS SQL Server :-)