Subject | Re: Updating index statistics |
---|---|
Author | lacakus |
Post date | 2007-01-02T10:49:32Z |
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 :-)
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 :-)