Answer Detail: RE: In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Wh

GeekInterview.com > Interview Questions > Oracle > Scenarios

Print |

Question: In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why

June 06, 2005 02:49:55	#1
hema	Member Since: Visitor Total Comments: N/A
RE: In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Wh
You have to run the analyze command during off peak time only because it actually performs full table scan.