Found out that the stats on these tables had been previously locked by the DBA before.
The 'auto optimizer stats collection job' will gather stats on all objects. You don't need to specifically set monitoring on any tables.
Thanks.
Regards, Sheryl
|
Results 1 to 3 of 3
Threaded View
|
Click Here to Expand Forum to Full Width |