Tom,

> I've a 10.6GB FDB (made up of 4 long thin tables) and find that
> creating an index takes 3-4 hours+.

have you tried directing the Firebird temporary directory -
controlled by the configuration file - to a RAM disk.

>
> During the latter stages of a restore similar effects occur.

Not surprising, because the last stage of a restore creates
indexes.

>

Regards,


Ann