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
In which three situations can dynamic statistics be used? (Choose three.)
-
- Site Admin
- Posts: 899558
- Joined: Mon Aug 02, 2021 8:13 am