Subject | Re: [firebird-support] best way to set statistics index on new database |
---|---|
Author | Ann W. Harrison |
Post date | 2007-08-22T15:14:14Z |
Bill Oliver wrote:
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
> Hello all!The cleanest way to do it is to
>
> 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.
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