欢迎来到天天文库
浏览记录
ID:34241032
大小:249.91 KB
页数:29页
时间:2019-03-04
《Oracle_select_upgrade.pdf》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、Oracle9i的查询优化Oracle白皮书2002年2月Oracle9i的查询优化执行概要..............................................................................................4简介......................................................................................................4什么是查询优化程序?........................
2、......................................4Oracle在查询优化方面提供了什么?......................................4SQL语句转换....................................................................................5试探查询转换..............................................................................6简单视图合并
3、......................................................................6复杂视图合并......................................................................6子查询“展平”.......................................................................7传递谓词生成...............................................
4、.......................8消除通用子表达..................................................................9谓词下推和上移..................................................................9用于“CUBE”查询的分组修整......................................10外联接到内联接的转换...........................................
5、.........11基于开销的查询转换................................................................11实体化视图重写................................................................11OR扩展............................................................................12星型转换...................................
6、.........................................12外联接视图的谓词下推....................................................14选择访问路径....................................................................................14联接排序.............................................................................
7、.......15适应式查找策略................................................................15多重初始排序试探............................................................16位图索引....................................................................................16位图联接索引................................
8、........................................
此文档下载收益归作者所有
点击更多查看相关文章~~