Hi,

2 Questions

a)Can "set isolation to dirty read " read a table while "update statistics high " is in progress on that table.

b) Can you run multiple "update statistics high" statements on different tables at the same time (same database).


Many Thanks
TC

Hi TC,

The answer to your questions -

a) Yes you can read a table when isolation is set to read mode & update statistics high is in progress for that table.

b) Yes you can mulitple update statistic high on diff. tables at the same time for the same database
eg.
update statistics high for table customers;
update statistics high for table orders;


Regards,

lloyd

Many Thanks.

TC