--- In firebird-support@yahoogroups.com, Pavel Cisar <pcisar@i...>
wrote:

> [...] I also suppose, that empty
> database was created when your application was installed, including

all

> indices.

Yes, that's true. Our users start with a nearly empty database.

> If you don't update index statistics in your application, or
> don't perform restore from backup from time to time, then index
> statistics are not updated (in fact, they are completely useless)

and

> optimizer can't do its best. Updated index stats itself can be the
> reason for observed performance boost.

Thanks for the suggestion...

During development and testing we frequently destroy and restore
databases from backups. I think that is why we didn't see this in our
testing.

I'm not familiar with updating index stats. Is that feature
available through ODBC... or do I need to use the services API?

Thanks again!

David