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?

No.

> -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
http://www.upscene.com