QUERY IN
|
|
\ /
-----------------------------------
| Is there a hint for table access, |
| an ORDERED, FIRST_ROWS or |
| ALL_ROWS hint ? |
| | yes
| 7.3+ Does any table have PARALLEL |-------> COST
| set ? |
| or |
| Partition Views involved? |
| |
| 8.0+ As above and additionally, |
| Are there any: |
| Index Organised Tables (IOT) |
| or |
| Partition Tables involved ? |
| |
| 8.1+ As above and additionally, |
| Are there any: |
| Domain Indexes (Inter Media) |
| or |
| Parallelism set on Indexes |
| See [NOTE:70008.1] |
| or |
| Parallel instances set on |
| an object |
| or |
| Sample clauses |
| (Datawarehousing feature) |
| or |
| Parallel CTAS |
| or |
| Function-based indexes |
| or |
| Reverse Key Indexes |
| or |
| Query rewrite |
| (materialised views) |
| or |
| ANSI JOIN syntax is used |
| in the query |
-----------------------------------
|
| no
|
----------------------------------- yes
| Is there a RULE hint ? |-------> RULE
-----------------------------------
|
| no
|
-----------------------------------
| Is RULE set at SYSTEM or SESSION | yes
| level and no CHOOSE hint ? |-------> RULE
-----------------------------------
|
| no
|
-----------------------------------
| Is ALL_ROWS or FIRST_ROWS set at | yes
| SYSTEM or SESSION level and no |-------> COST
| CHOOSE hint ? |
-----------------------------------
|
| no
|
-----------------------------------
| Are there statistics for any of | yes
| the tables ? |-------> COST
-----------------------------------
|
| no
|
RULE
分享到:
相关推荐
CBO,RBO在ORACLE中的应用
ORACLE CBO RBO 优化
主要介绍了Oracle的RBO和CBO详细介绍和优化模式设置方法,RBO即基于规则的优化方式(Rule-Based Optimization),CBO即基于代价的优化方式(Cost-Based Optimization),需要的朋友可以参考下
oracle数据库执行计划文档,描述了cbo,rbo等优化方式,以及数据库执行计划的稳定性
CBO学习代码 Jonathan Lewis编写
cbooracle cbo
关于oracle的CBO下的HINT总结!
cbo数据库优化,数据性能,oracle性能分析优化
A Look under the Hood of CBO - the 10053 Event
how_cbo_works
平安Oracle CBO 资料.doc
【Maclean Liu技术分享】拨开Oracle CBO优化器迷雾,探究Histogram直方图之秘_0321.pdf
asp.net cbo实现多行选中,里面有案例和dll..可以直接套用。。非常好用
matlab巴特沃斯代码CBO4过滤器 使用称为碰撞体优化 (CBO) 的元启发式优化技术,根据整数阶有理近似设计分数阶低通巴特沃斯滤波器的 ...以往的研究表明,CBO的性能非常好,也很容易实现。 其他类型的数字滤波器也可以用
基于CBO的Oracle的成本分析.pdf
Things_You_Should_Know_About_11g_CBO
asp.net cbo实现多行选中,里面有案例和dll..可以直接套用。。非常好用
C# cbo和dgv输入筛选下拉列表,可以直接套用。非常简单,好用
数据库REDO日志挖掘与优化CBO执行计划查询.