How would you prevent the optimizer from using the newly collected statistics for other sessions immediately after statistics collection?

You plan to collect statistics for an important table in your database to help improved query
performance. You are uncertain about the optimizer behavior after the statistics have been
collected because currently there are no statistics for indexes or partitions on the table. You wish
to test the performance effect of the newly collected statistics. How would you prevent the
optimizer from using the newly collected statistics for other sessions immediately after statistics
collection?

You plan to collect statistics for an important table in your database to help improved query
performance. You are uncertain about the optimizer behavior after the statistics have been
collected because currently there are no statistics for indexes or partitions on the table. You wish
to test the performance effect of the newly collected statistics. How would you prevent the
optimizer from using the newly collected statistics for other sessions immediately after statistics
collection?

A.
Set the PUBLISH preference to FALSE for the table.

B.
Set the NO_VALIDATE preference to TRUE for the table.

C.
Set the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.

D.
Set the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter to FALSE for the session.

E.
Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE for the session.



Leave a Reply 1

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


L. Zhu

L. Zhu

A is right.