Which two statements are true about gathering statistics?

Which two statements are true about gathering statistics? (Choose two.)

Which two statements are true about gathering statistics? (Choose two.)

A.
If an application has only SQL statements with bind variables, it is better to drop existing
histograms, disable creation of histograms, and allow the optimizer to select the best
execution plans.

B.
If end users query newly inserted data, it is possible to get a suboptimal execution plan
even if the automatic statistics gathering job is enabled.

C.
If concurrent statistics gathering is done by using parallel execution, the Resource
Manager should be used for efficient resource management.

D.
For each session that is accessing a global temporary table, the optimizer uses only the
shared statistics.



Leave a Reply 3

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


Micch

Micch

imo B and C are right.
A wrong, it is valid prior 11G.
D wrong, 12c uses session stats for GTT too

vasya

vasya

agree, B and C sounds good here

Fonx

Fonx

Yep B C seems only possibility