⟩ 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.
Question and Answer:
Home Oracle Scenarios
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain Which datatype is used for storing graphics and images?
Explain Difference between an implicit and an explicit cursor?
Explain ROWID?
Please Explain Connect by Prior?
Explain What is a database link?
Explain Explicit Cursor attributes?
Explain What is a corelated subquery?
Explain How to drop the index?
What is a join in Oracle? Explain the different types of joins?
Explain What are the data types allowed in a table?
