Also, would an explicit LOCK TABLE before running stats help in preventing these deadlocks?
________________________________ From: T K <[email protected]> To: Derby Discussion <[email protected]> Sent: Friday, August 21, 2009 11:27:56 AM Subject: Re: Running stats while online > I have sometimes seen timeouts and deadlocks as a result of this when > updating the statistics while other threads are accessing the same table. Have you seen this with 10.5 and its new approach as well? Or just prior versions? Thanks
