试题详情
- 单项选择题In which cases is reference partitioning effective in enhancing performance？（）
A、 It is effective only in partition pruning.
B、 It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C、 It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D、 It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
- D
关注下方微信公众号，在线模考后查看
热门试题
- Which two̳
- 下面的函数，（）用于返回时区信息。
- View the E
- 下列哪个不是有效的数据库状态？（）
- Which of
- Which of
- The job t
- Given: Whatistheres
- 说明数据库内存结构中SGA和PGA的组成
- You discover that y
- Examine the structu
- You want
- 初始化参数（）指定了实例启动时希望创建的
- What are three facts
- What command&#
- ExaminetheCREATEDISK
- Viewtheexhibitandexa
- You noticeQ
- While designin
- SQL语言中用来创建、删除及修改数据库对