Subject | Updating index statistics |
---|---|
Author | Adam |
Post date | 2007-01-02T00:14:47Z |
Hello Group,
Is there a single command in Firebird to reset the statistics of every
index? Failing that, is it safe to call set statistics from an execute
statement PSQL so I can write a trivial stored procedure to do it?
Can set statistics be called safely on an active database or must it
be done with the database shutdown?
Thanks in advance
Adam
Is there a single command in Firebird to reset the statistics of every
index? Failing that, is it safe to call set statistics from an execute
statement PSQL so I can write a trivial stored procedure to do it?
Can set statistics be called safely on an active database or must it
be done with the database shutdown?
Thanks in advance
Adam