Procedure to rebuild all indexes
After reading news about rebuilding Firebird indexes, I wrote a procedure for Windows, which allows fully automatic rebuild all indexes in the Firebird database. The procedure is described on my website http://gskoczylas.rekord.pl/Firebird/AutoReindexAll.php (in Polish). Automatic translation into English is here: http://goo.gl/9Uu96.
At the end of the web page there is a link which allows to download the complete procedure. Procedure has been tested on Windows Vista with Firebird 2.5.
—
Regards,
Grzegorz Skoczylas
gskoczylas@gmail.com
Loading...
It’s necessary to say that such rebuilding of indices (as well as majority of metadata operations) should be performed in exclusive mode.
Do not run it while users are actively write or update records, it can lead to corruption.