Oracle
1Z0-064 · Question #3
In which three situations can dynamic statistics be used? (Choose three.)
The correct answer is A. when the sampling time is a small fraction of the total time for a query B. when an execution plan is suboptimal because of complex predicates C. when extended statistics are not available for SQL statements that use complex predicates. https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341
Managing Database Performance
Question
In which three situations can dynamic statistics be used? (Choose three.)
Options
- Awhen the sampling time is a small fraction of the total time for a query
- Bwhen an execution plan is suboptimal because of complex predicates
- Cwhen extended statistics are not available for SQL statements that use complex predicates
- Dwhen a query is on a partitioned table with a global index
- Ewhen index statistics are missing on a column that is used in SQL statements with highly
How the community answered
(39 responses)- A72% (28)
- D15% (6)
- E13% (5)
Explanation
https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341
Topics
#dynamic statistics#query optimization#complex predicates#execution plan
Community Discussion
No community discussion yet for this question.