Re: Code to Save & Recreate Indexes

In article <51vtdh$1j7@gulfa.kuwait.net>, rferdy@kuwait.net (Rudy Fernandes) wrote: >In article <Pine.SUN.3.91.960919141134.21833A-100000@tyrell.net>, > Daniel Martin <drmartin@tyrell.net> wrote: >> >>Below is a way I used to save Index info for an entire database. >> Another solution, is to use the INFORMIX bcheck utility, but with the -s flag, which forces recreation of all indexes. The script could go like this : - : # Script to force recreation of all indexes in a database cd $DBPATH for target in *.dat do bcheck -s $target done rm *.IDX # Temporary index file created by bcheck