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.


Dmitry