kc第15讲RDBMS的查询优化技术课程.pptVIP

* * * * * * In general, SQL queries of the form below can be rewritten as shown To : select … from L1 where P1 and exists (select * from L2 where P2) Firstly: create table t1 as select distinct V from L2 where P21 P21 contains predicates in P2 that do not involve any correlation variables V contains all attributes used in predicates with correlation variables Then rewrite：select … from L1, t1  where P1 and P22 P22 rei