update rdb$indices set rdb$statistics = -1

seems to do the trick

----- Original Message -----
From: "Kjell Rilbe" <kjell.rilbe@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, August 17, 2008 1:23 AM
Subject: [firebird-support] Statistikcs?


> Hi,
>
> I know I can manually update the statistics for an index using the set
> statistics clause.
>
> But when/how are the index statistics updated automatically? Are they
> maintaned automatically at all?
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>