9.1 电子表格.......................................................................................................49
9.2 通过 MODEL 子句进行跨行引用........................................................................49
9.3 位置和符合引用..............................................................................................50
9.4 返回更新后的行..............................................................................................52
9.5 求解顺序.......................................................................................................53
9.6 聚合.............................................................................................................54
9.7 迭代.............................................................................................................55
9.8 查询表..........................................................................................................56
9.9 空值.............................................................................................................56
9.10 使用 MODEL 子句进行性能优化......................................................................56
9.11 子查询因子化...............................................................................................57
9.12 小结...........................................................................................................57
10 子查询因子化......................................................57
10.1 标准用法.....................................................................................................57
10.2 SQL 优化..................................................................................................... 57
10.3 递归子查询..................................................................................................58
10.4 复制 CONNECT BY 的功能............................................................................59
10.5 小结...........................................................................................................61
11 半联结和反联结...................................................61
11.1 半联结........................................................................................................61
11.2 半联结执行计划............................................................................................61
11.3 控制半联结执行计划.....................................................................................61
11.4 半联限制条件...............................................................................................61
11.5 半联结必要条件............................................................................................61
11.6 反联结........................................................................................................61
11.7 反联结执行计划............................................................................................61
11.8 控制反联结执行计划.....................................................................................62
11.9 反联结限制条件............................................................................................62
11.10 反联结必要条件..........................................................................................62
11.11 小结.........................................................................................................62
12 索引................................................................62
12.1 理解索引.....................................................................................................62
12.2 索引结构类型...............................................................................................65
12.3 分区索引.....................................................................................................65
12.4 与应用特点相匹配的解决方案.........................................................................65
12.5 管理问题的解决方案.....................................................................................66
12.6 小结...........................................................................................................66
