Oracle Scenarios Question:
Download Job Interview Questions and Answers PDF
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
Answer:
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 Question | Next Question |
Explain If the SQL * Plus hangs for a long time, what is the reason? | Explain What is bulk SQL? |