| difference between locking and disabling statistics [message #277353] |
Mon, 29 October 2007 13:37  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
Hi,
can anyone brief me the difference between disabling the automatic statistics collection and locking the statistics.
Scenario 1:
Imagine I disabled the automatic statistics gathering for whole db and consider now I am collecting the statistics for the table manually. After collecting the statistics if I am not locking the statistics. Will it keep updating, eventhough I disabled the auto stats gathering?
Why I am asking is document says, statistics will keep updated if we are not locking the stats gathering, is it?
With Regards
Boo
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
