Subject | Re: [IB-Architect] Index Sync/Rebuild Question |
---|---|
Author | Markus Kemper |
Post date | 2000-04-28T15:13:02Z |
> Except for one very common situation. Create your database. Populate it withInteresting. Instead of burp-ing the database you could
> 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.
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 ...
Markus