Subject Re: [firebird-support] best way to set statistics index on new database
Author Ann W. Harrison
Bill Oliver wrote:
> Hello all!
>
> I have a user who creates his databases, creates tables, inserts
> initial data, and then wants to set the statistics on the indexes he
> just created.

The cleanest way to do it is to

1) Create databases
2) Create tables
3) Load data & commit
4) Create indexes

That sequence reduces load time, creates dense indexes, and
sets the statistics correctly.


Regards,


Ann