Subject | About statistics |
---|---|
Author | ainpoissee |
Post date | 2007-04-25T15:32:01Z |
Hi,
Is it true that FB updates statistics each time after all users log
out and before the first user logs back in? So that occasional SET
STATISTICS is really only needed in "true 24/7 apps" where there is at
any given time always at least one user connected to the database?
Also, is the isql's SET STATISTICS the only official way to update
statistics (apart from backup/restore cycle)? I have seen suggestions
to use
UPDATE RDB$INDICES SET RDB$STATISTICS = -1;
how safe it is?
TIA
ain
Is it true that FB updates statistics each time after all users log
out and before the first user logs back in? So that occasional SET
STATISTICS is really only needed in "true 24/7 apps" where there is at
any given time always at least one user connected to the database?
Also, is the isql's SET STATISTICS the only official way to update
statistics (apart from backup/restore cycle)? I have seen suggestions
to use
UPDATE RDB$INDICES SET RDB$STATISTICS = -1;
how safe it is?
TIA
ain