Subject | Index Selectivity maintenance |
---|---|
Author | Ian A. Newby |
Post date | 2004-03-09T14:47:14Z |
Hi Folks,
I'm just wondering what is the best way to automatically
recalculate the index selectivity. I know that a backup and restore
will do this but I'm after doing it with no downtime about once a
month.
Is there any way to do a global selectivity recalculation through
isql, gfix or similar?
Regards
Ian Newby
I'm just wondering what is the best way to automatically
recalculate the index selectivity. I know that a backup and restore
will do this but I'm after doing it with no downtime about once a
month.
Is there any way to do a global selectivity recalculation through
isql, gfix or similar?
Regards
Ian Newby