--- In firebird-support@yahoogroups.com, "emb_blaster"
<EMB_Blaster@...> wrote:

>
>
> I´ve found this SQL by Fabiano almost like mine... But still don´t
> understand why FB do not do it automaticaly...

When and how often should FB automatically do it?

Indices that are valuable *may* become less so over time, and vice
versa, useless indices *may* eventually become valuable.

But if the general shape of your data remains reasonably constant,
then there is never any need to run it. I agree it could be made
easier with a built in command and/or a sweep interval style per
database setting, but in practice I have never really encountered the
need to update statistics very often.

Adam