On 1/8/07, Hans <hhoogstraat@...> wrote:

> The previously here posted one liner Executed
> at a scheduled or time or manual choice works just
> great. 'update rdb$indices set rdb$statistics = -1'

Can someone explain what this does exactly? Is there a system trigger
that fires and recalculates the statistics at once? Or is
recalculating deferred until the next time the statistics are read?

I suppose that SET STATISTICS will recalculate immediately?

TIA,
Markus