- 4
- 0
- 约3.86千字
- 约 73页
- 2020-10-15 发布于上海
- 举报
Query Processing;Overview of Query Execution;Step 1: Parsing;Example: SQL query;Example: Parse Tree;Step 2: Parse Tree - Logical Query Plan;Example: Logical Query Plan;Step 3: Improving the L.Q.P;Example: Improved Logical Query Plan;Step 4: Estimate Result Sizes;;Steps 5, 6, ...;Example: One Physical Plan;Example;Relational Algebra - used to describe logical plans; R A B C S C D E
a 1 10 10 x 2
b 1 20 20 y 2
c 2 10 30 z 2
d 2 35 40 x 1
e 3 45 50 y 3; How to execute query?;RxS R.A R.B R.C S.C S.D S.E
a 1 10 10 x 2
a 1 10 20 y 2
.
原创力文档

文档评论(0)