Which two statements are true about the use of the DYNAMIC_SAMPLING hint in a query?

Question

Options

• AIt estimates selectivity better for the filters.
• BIt is always used for flashback queries that contain the AS OF clause.
• CIt cannot be used if there is a single-table predicate in the WHERE clause.
• DIt cannot be used for processing SQL statements in parallel.
• EIt can compensate for the lack of extended statistics to get accurate cardinality estimates for complex

• A
  8% (2)
• B
  4% (1)
• C
  16% (4)
• D
  72% (18)

Explanation

D: For parallel statements, the optimizer automatically decides whether to use dynamic sampling and which level to use. The decision depends on the size of the tables and the complexity of the predicates. The optimizer expects parallel statements to be resource-intensive, so the additional overhead at compile time is worth it to ensure the best plan. The database ignores the For serially processed SQL statements, the dynamic sampling level depends on the value of the OPTIMIZER_DYNAMIC_SAMPLING parameter and is not triggered automatically by the optimizer. Serial statements are typically short-running, so that any overhead at compile time could have a huge impact on their performance. the value is honored.

No community discussion yet for this question.