Oracle Scenarios Question:
Download Questions PDF

Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?


We have to run the analyze command during off peak time only because it actually performs full table scan.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Explain If the SQL * Plus hangs for a long time, what is the reason?Explain What is bulk SQL?