which three situations can dynamic statistics be used?

In which three situations can dynamic statistics be used? (Choose three.)

In which three situations can dynamic statistics be used? (Choose three.)

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

D.
when a query is on a partitioned table with a global index

E.
when index statistics are missing on a column that is used in SQL statements with highly selective filters

Explanation:
https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341



Leave a Reply 0

Your email address will not be published. Required fields are marked *