Subject Re: [IB-Architect] Index Sync/Rebuild Question
Author Markus Kemper
> Except for one very common situation. Create your database. Populate it with
> data. Start using it. Then check the selectivity. You will find that almost
> every index will have 0 - the selectivity that existed when the db was
> created. Of course a backup and restore will fix this.

Interesting. Instead of burp-ing the database you could
write a query to generate a script to compute the selectivity
on all your newly populated indexes.

select 'set statistics ', rdb$index_name, ';'
from rdb$indices where rdb$index_name ...