Tom Miller wrote:

> On a large table (lots of records / rows) the DB has to recalculate the
> index on every record.
>
> I did a test on a 3.7 GB database
>
> No -i Flag: 35 minutes
> with -i Flag: 24 minutes
>
> Activating the indexes through DB Workbench took about a minute, so that
> was 10 minutes faster.
>
> Tom Miller
>

Hi !

AFAIK gbak activates the indices after the data load. This is why I
think your approach should not give any benefit (unless you don't
activate all indices)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br