Alec Swan wrote:

>
> I am having hard time finding comprehensive documentation on database
> maintenance tasks. Specifically, how do I reorganize or rebuild indexes in
> Firebird? How do I update statistics? Are there any other maintenance tasks
> I need to know about? Is there a document that talks about this?
>

In theory, you shouldn't have to rebuild or reorganize Firebird indexes.
Our indexes don't get out of balance (generally) or develop holes.
As pages fill they split leaving room for new entries if the index has
entries added in random order, or split at the end if new entries are
generally in index order. Nearly empty pages are recombined. There is
a SET STATISTICS statement that should be used from time to time to
reset the selectivity and improve join order optimization.

Good luck,

Ann