What can you do to 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
and 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 in
regular intervals: SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS(‘SH’,’SALES’,GRANULARITY=>’GLOBAL’); You
need statistics to be collected more quickly. What can you do to 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
and 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 in
regular intervals: SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS(‘SH’,’SALES’,GRANULARITY=>’GLOBAL’); You
need statistics to be collected more quickly. What can you do to achieve this?

A.
Set DYNAMIC_SAMPLING to level 4.

B.
Set the STATISTICS_LEVEL parameter to BASIC.

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

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

Explanation:



Leave a Reply 0

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