In which three situations can dynamic statistics be used? (Choose three.)
Posted: Sun Jun 11, 2023 3:51 pm
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
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