--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> 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.

Thanks Dmitry.

Adam