Re: Q: Update statistics

Hi Susan, Update statistics set read locks while touching a table. This means thatother read sessions (select ...) are working, but writing jobs (ins/upd/del) must wait or will be canceled (depending on the lock mode) till update statistics jumps to the next table. Hope this helps Uwe -- Xerox your life - If you'll loose it, it's nice to have a copy Uwe Feuerstein iXOS Anwendungssoftware GmbH Leipzig, Germany E-Mail: mailto:Uwe.Feuerstein@ixos-leipzig.de WWW : http://www.ixos.com/leipzig Susan Elliott (ISG) wrote: > > Howdy folks, > > What is the effect to the users if they are using the system while > running update statistics is running ? What is, if any is the effect to > my update statistics ?? > > TIA > Suze