On [Thu, 27.08.2009 12:58], Dmitry Yemanov wrote:

> Daniel Vogelbacher wrote:
> >
> > Firebird 2.0.5 SS Win32
>
> Database is in ODS11, I hope?

Yes, gstat return 11.0.

>
> > But afaik a simple count(*) without a WHERE clause isn't using
> > any indicies, so it's not an index issue.
>
> Indices are being garbage collected in this case.

You mean that the first query cleans up the indicies
and after gc has finished, the query runs faster?


--
web: http://daniel.vogelbacher.name
irc: cytrinox @ (freenode|ircnet|quakenet)