皮皮学,免费搜题
登录
logo - 刷刷题
搜题
【多选题】
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?()
A.
Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
B.
Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
C.
Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
D.
Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
E.
Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
F.
Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案:
举一反三
【简答题】阅读理解 A few years ago when my daughter was about two years old,I went through a difficult time.My marriage was in trouble,I was pregnant (怀孕的) and not particularly well and I didn't have much money. Lo...
【简答题】根据汉语提示完成下列句子。 1. The readers want _______  (与… …交流) the writers. 2. Lucy wants to be _______.(电脑程序设计师) 3. There are lots of _______ (精彩的时装表演) in Shanghai this year. 4. The painters are going to ______...
【简答题】My daughter was so ______ in the TV programme that she forgot to turn the microwave oven off. A. distracted B. attracted C. enchanted D. engrossed 2. Tourists are ______ to beware of pickpockets in th...
【多选题】髂腰肌是由 和 两块肌肉组成。
A.
髂肌
B.
腰大肌
【单选题】髂腰肌由髂肌和什么组成。
A.
腰小肌
B.
腰大肌
C.
臀中肌
D.
臀大肌
【单选题】发动机冷却水大循环时,冷却水流经()
A.
散热器流向缸盖
B.
水泵流向散热器
C.
散热器流回水泵
【简答题】告警模块的I/O接口板上的TB6接口的作用是为()。
【简答题】下列关于附条件和附期限的民事法律行为说法错误的是( )。
【单选题】Lucy wants ___ a teacher. [     ]
A.
to be
B.
be
C.
being
D.
is
【简答题】AL175NT告警模块I/O接口板上的TB6接口的作用是()。TB4接口的1、2引线端的作用是(),它们分别连接到整流器输出的正负汇流条上;TB1的作用是(),TB2是告警信息继电器输出接口。
相关题目:
参考解析:
知识点:
题目纠错 0
发布
创建自己的小题库 - 刷刷题