|Subject||Re: Updating index statistics|
--- In email@example.com, Dmitry Yemanov <dimitr@...>
> Adam wrote:
> > Is there a single command in Firebird to reset the statistics of every
> > index?
> No, there's not.
> > is it safe to call set statistics from an execute
> > statement PSQL so I can write a trivial stored procedure to do it?
> Yes, it's safe. Just don't forget to commit.
> > Can set statistics be called safely on an active database or must it
> > be done with the database shutdown?
> It can be collected on an active database.