great, thanks everyone for all your help with this and other questions
on behalf of all those who ask these questions, we do appreciate the
answers given.

. On 27/01/07, Ivan Prenosil <Ivan.Prenosil@...> wrote:

> > thanks now I understand it effects better but I still don't see which
> > process is the 'it' that does the recalculation
>
> It is done in the transaction that was used do recompute statistics -
> not when you run SET STATISTICS, but when that transaction commits.
>
> Ivan
> http://www.volny.cz/iprenosil/interbase/
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>