Subject | How recompute all indexes |
---|---|
Author | Kulheim Jaroslav |
Post date | 2005-02-03T12:43:28Z |
Hello,
instead of daily backup/restore I'd like to recompute automatically all
indexes, something that will generate following script for isql:
alter index A inactive;
alter index A active;
...
alter index Z inactive;
alter index Z active;
Is there any solution with standard command line programs - isql, gpre ?
Thanks, Jaroslav Kulheim
instead of daily backup/restore I'd like to recompute automatically all
indexes, something that will generate following script for isql:
alter index A inactive;
alter index A active;
...
alter index Z inactive;
alter index Z active;
Is there any solution with standard command line programs - isql, gpre ?
Thanks, Jaroslav Kulheim