| Update statistics [message #376474] |
Wed, 17 December 2008 08:21  |
danyromimd
Messages: 73
Registered: August 2008
|
Member |
|
|
Hi!!
I've got a question...
Is it recommended to run an "update statistics" after recovering a database from backup?
When is it recommended an which is the oracle command for doing it?
Thanks!!
Daniela.
|
|
|
|
| Re: Update statistics [message #376483 is a reply to message #376474] |
Wed, 17 December 2008 09:36  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Is it recommended to run an "update statistics" after recovering a database from backup?
Depends. If the physical layout of disks has changed (database files may still go to the same "path"), it is better.
>>When is it recommended an which is the oracle command for doing it?
The same command that was used before restore?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
