当前位置： 文档下载 > 所有分类 > IT/计算机 > Introduction to the OptimizerIntroduction to the Optimizer
Introduction to the Optimizer
Overview of SQL Processing
1. parser 进行语意和语法分析
2. Optimizer 利用RBO,CBO等方法决定产生查询结果的最有效路径
3. Row Source Generator 从2中接受优化后的方案，并产生SQL的Execution Plan
4. SQL Execution Engine运行该执行计划，并产生查询结果
Features that Require the CBO
1. Partitioned tables and indexes
2. Index-organized tables
3. Reverse key indexes
4. Function-based indexes
5. SAMPLE clauses in a SELECT statement
6. Parallel query and parallel DML
7. Star transformations and star joins
8. Extensible optimizer
9. Query rewrite with materialized views
10. Enterprise Manager progress meter
11. Hash joins
12. Bitmap indexes and bitmap join indexes
13. Index skip scans
即使OPTIMIZER_MODE＝rule，这些features仍然会使用CBO
Components of the CBO
Query Transformer
An introduction to the Bootstrap method_英语_小学教育_教育专区。自助法简介An introduction to the Bootstrap method Hugh Shanahan University College London Novem...
For the latest release of Interactive Optimizer including updated Help, visit our Web site. Introduction An introduction to Interactive Optimizer and its ...
The introduction to a movie_院校资料_高等教育_教育专区。The film Titanic was made by Hollywood. It tells us a really moving story. Rose is a ...
Introduction to the LLVM Compiler System_互联网_IT/计算机_专业资料。...? New Features http://llvm.org Potential Impact of LLVM Optimizer ? ...
Introduction to the UK_英语考试_外语学习_教育专区。英美文化概况Exercises for Brief Introduction to the UK I. Decide whether the following statements are tru...
编译原理第一章Introduction to Course_工学_高等教育_教育专区。北京化工大学编译...6 ● The target code optimizer MOV R0, index SHL R0 MOV &a[R0],6 20...
A brief introduction to the company_专业资料。公司简介:宁波明兴金融设备实业有限公司,是一家集各类智能型箱柜、手动、电动密集架、档案图书装具,防磁柜、保管箱...
Lecture 0-Introduction to the Course_工学_高等教育_教育专区。同济大学数据库英文版课件 Database System Concepts 《数据库系统原理》 (Spring 2012) Guan ...
Introduction to the EHS Module-环境健康与安全简介_环境科学/食品科学_工程科技_专业资料。Environmental Health and Safety-IntroductionENVIRONMENTAL...
The Introduction to The London School_英语学习_外语学习_教育专区。The Introduction to The London School The London School, as we know, is a main branch...
我要评论