Quiz 1Z0-054, Oracle Database 11g: Performance Tuning
What would you do to increase the interval of statistics collection for these tables
What would you recommend to reduce the I/O?
What could be the reason?
Why is the query using a full table scan instead of an index scan?
What would you recommend to improve the optimizer’s estimation?
What can you do to make the optimizer detect the actual number of rows?
Why would the optimizer choose full table scan over index unique scan?
What could be the reason for it?
Select three correct interpretations of the time model statistics…
Which action would solve this problem?