Subject Re: [firebird-support] Re: Firebird optimize table
Author Ann W. Harrison
emb_blaster wrote:
>> (...) Computing the selectivity of an index
>> is done on load, but not redone after major changes. (...)
> Sorry, what load? Database load? Indexes load? I donĀ“t see it cleary...

I was not clear - I meant index creation. If you create an index on
an empty table you'll need to set the selectivity after loading data.
If you create an index on a full table, you'll get a plausible
selectivity. Most load utilities start with indexes undefined or
disabled, then create or enable the indexes - that will give good