Subject | Re: [firebird-support] best way to set statistics index on new database |
---|---|
Author | Ann W. Harrison |
Post date | 2007-08-22T15:23:27Z |
Martijn Tonies wrote:
=>>
then set statistics, when creating indexes after the data is loaded
is faster, builds better indexes, and gets the statistics right
automatically?
Cheers,
Ann
=>>
>> Here is the what he came up withBut for a newly created database, why build indexes incrementally
>>
>> EXECUTE BLOCK AS ...
>>
>> This is ok, I guess. I wondered if there was a cleaner way to do this,
>> though?
>
> Well, this is how I do it in production databases :-)
>
then set statistics, when creating indexes after the data is loaded
is faster, builds better indexes, and gets the statistics right
automatically?
Cheers,
Ann