Oracle Scenarios Question: Download Oracle Scenarios 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.
| Previous Question | Next Question |
| Explain If the SQL * Plus hangs for a long time, what is the reason? | Explain What is bulk SQL? |