How do you achieve this?

You have a range-partitioned table in your database. Each partition in the table contains the sales
data for a quarter. The partition related to the current quarter is modified frequently, whereas other
partitions undergo fewer data manipulations. The preferences for the table are set to their default
values. You collect statistics for the table using the following command at regular intervals:
SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS(‘SH’,’SALES’,GRANULARITY=>’AUTO’);You need
statistics to be collected more quickly. How do you achieve this?

You have a range-partitioned table in your database. Each partition in the table contains the sales
data for a quarter. The partition related to the current quarter is modified frequently, whereas other
partitions undergo fewer data manipulations. The preferences for the table are set to their default
values. You collect statistics for the table using the following command at regular intervals:
SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS(‘SH’,’SALES’,GRANULARITY=>’AUTO’);You need
statistics to be collected more quickly. How do you achieve this?

A.
Set the PUBLISH preference to TRUE for the partition table.

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

C.
Set the INCREMENTAL preference to TRUE for the partition table.

D.
Increase the value of the STALE_PERCENT preference for the partition table.



Leave a Reply 1

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


L. Zhu

L. Zhu

By change INCREMENTAL preference from default FALSE to TRUE, will help reduce stats collection time for partitioned table, if only the current partition is frequently changed.

So C is correct