db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Rørdam <CRoer...@oslo.westerngeco.slb.com>
Subject Performance affected by adding a column?
Date Fri, 14 Dec 2007 12:24:27 GMT
We have a Derby database version of size about 1.5 GB. Some people here say they have
noticed a performance degradation after adding a new column to an existing table. The table
has about 12 000 rows.

Is it normal that performance will degrade after adding a new column? And if so, is there
something special one should do when adding columns?

Christian Rørdam
Schlumberger OFS - IT Business Systems

View raw message