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 prefer

题目

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

参考答案和解析

正确答案:C

更多“You have a range”相关问题

第1题

Our stocks include a wide range of first-class electrical typewriters at very competitive prices.They have the correcting and automatically storing system. From the catalogues enclosed, you will find that our prices are much lower than those in the market.(英译中)

点击查看答案
第2题

Could you please tell me ____________________ ?A、how long have you lived hereB、how long you lived hereC、how long you have lived hereD、you have lived here how long

点击查看答案
第3题

Given that you have a class B IP address network range, which of the subnet masks below will allow for 100 subnets with 500 usable host addresses per subnet?A．255.255.0.0B．255.255.224.0C．255.255.254.0D．255.255.255.0E．255.255.255.224

点击查看答案
第4题

The following output exists on Router R1, a router internal to area 1. What can you d etermine as true from the output of the show ip ospf database summary command?()A. The LSA was created by an ABR due to an area range command.B. The LSA was created by an ASBR due to a summary - address command.C. If cr eated by an area range command, the best metric for a subordinate subnet on that ABR must have been 11.D. None of the other answers is correct.

点击查看答案
第5题

You are entering port and have been instructed to anchor，as your berth is not yet available．You are on a SW'ly heading，preparing to drop anchor，when you observe the range lights as shown on your starboard beam．You should ______．A.not drop the anchor until the lights are in lineB.ensure your ship will NOT block the channel or obstruct the range while at anchorC.drop the anchor immediately as the range lights mark an area free of obstructionsD.drop the anchor immediately as a change in the position of the range lights will be an indication of dragging anchor

点击查看答案
第6题

His presentation will show you ____ can be used in other contexts. A. that you have observed B. that how you have observed C. how that you have observed D. how what you have observed

点击查看答案
第7题

Prof.Lee’s book will show you（）can be used in other contexts.A.that you have observed B.that how you have observed C.how that you have observed D.how what you have observed

点击查看答案

You have a range

题目

参考答案和解析

更多“You have a range”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容