Subject Re: [firebird-support] best way to set statistics index on new database
Author Ann W. Harrison
Martijn Tonies wrote:
=>>
>> Here is the what he came up with
>>
>> 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 :-)
>

But for a newly created database, why build indexes incrementally
then set statistics, when creating indexes after the data is loaded
is faster, builds better indexes, and gets the statistics right
automatically?


Cheers,


Ann