How would you achieve this?

You have statistics collected for some selected tables. Your requirement is that the statistics
for the tables and all dependent indexes must not be overwritten by further statistics
collection until a certain point of time. How would you achieve this?

You have statistics collected for some selected tables. Your requirement is that the statistics
for the tables and all dependent indexes must not be overwritten by further statistics
collection until a certain point of time. How would you achieve this?

A.
Change STALE_PERCENT to zero for the tables.

B.
Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

C.
Lock statistics for the tables.

D.
Set the TIMED_STATISTICS parameter to TRUE.

E.
Set the STATISTICS_LEVEL parameter to BASIC.



Leave a Reply 1

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