Re: Can someone tell me if syscs_util.update_statistics locks table/indexes being updated

2010-12-01 Thread Knut Anders Hatlen
Bergquist, Brett br...@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

Re: Can someone tell me if syscs_util.update_statistics locks table/indexes being updated

2010-12-01 Thread Kristian Waagan
On 01.12.2010 15:32, Bryan Pendleton wrote: On 12/01/2010 05:26 AM, Bergquist, Brett wrote: 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. The

RE: Can someone tell me if syscs_util.update_statistics locks table/indexes being updated

2010-12-01 Thread Bergquist, Brett
if syscs_util.update_statistics locks table/indexes being updated On 01.12.2010 15:32, Bryan Pendleton wrote: On 12/01/2010 05:26 AM, Bergquist, Brett wrote: 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