Skip to Content
0
Former Member
Jun 24, 2015 at 05:00 PM

update statistics and table access

14 Views

----------

Adaptive Server Enterprise/15.7.0/EBF 22639 SMP SP52 /P/Sun_svr4/OS 5.10/ase157sp5x/3293/64-bit/FBO/Wed May 21 02:49:14 2014

----------

Hi Community,

I'd like to know if it's allowed to run update statistics on day-time while people are connected to the system? or is it better to do it when there are no activities on the DB?

From my point of view if people just do some selects, the update statistics can be executed.

On the other, does 'update statistics' apply an exclusive lock?

Thank you

Simon