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
selectivity.

Regards,

Ann