Subject Modify database structure, add and drop indexes while in heavy use?
Author Caroline Beltran
I have a FB database 4 tables. I decided to add some columns, drop one index and create two indexes while the FB database handling a 12 hour long batch job.

Between all tables, these batch jobs consist of an average of 1 to 20 INSERTS per second and 10 to 40 UPDATES per second.  There are also approximately 5 selects (with JOINS) per second.

To avoid the expense of opening and closing connections, I am running a connection pool with 15 shared connections.

I don't want to bog this message down with excessive details and would like to know if performing modifications to the database running such a batch is a bad idea.  Thank you for your time.

I am using Firebird 2.5.4 Superserver on Windows 2012 64 bit.