Subject Re: [firebird-support] DB Admin tasks
Author Martijn Tonies
Hi Raymond,

> To compare FB against some other DB's... can someone tell me what DB
> Admin tasks are required (or should be done) weekly, monthly,
> quartly, etc?
> The existing DB has about 75 tables with the largest tables having
> around 300,000 to 750,000 records
> -Do I have to Pack (remove deleted records) periodically and how is
> this done?


> -Do I need to periodically re-index (re-build the indicies) and how
> is this done?

No. Or at least, perhaps - you can issue a SET STATISTICS on
an index, but usually this isn't needed.

> -What other DB admin tasks should be done and at what intervals?

Create a backup each day :-)

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions