db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Can someone tell me if "syscs_util.update_statistics" locks table/indexes being updated
Date Wed, 01 Dec 2010 14:48:30 GMT
"Bergquist, Brett" <Brett@canoga.com> writes:

> If I have a table with millions of rows and I invoke
> syscs_util.update_statistics on it, will the table/indexes be lock
> such that inserts or updates will fail while this is being done.

It used to lock the table exclusively, but that was fixed in
DERBY-4274/Derby Now it should only take an intention lock on
the table, which prevents other transactions from dropping the table,
but inserts and updates won't be blocked.

Knut Anders

View raw message