![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
《Pro Oracle SQL》Chapter 10 Subquery Factoring
caohong286
这个作者很懒,什么都没留下…
展开
-
《Pro Oracle SQL》Chapter 10 Subquery Factoring --10.1 Standard Usage
Subquery Factoring 子查询分解 (page 305)Jared Still You may not be familiar with the term subquery factoring . Prior to the release of Oracle 11gR2, the official Oracle documentation barely...2012-05-02 22:46:07 · 148 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter10 -- 10.2 Optimizing SQL -10.2.1Testing Execution Plans
10.2 Optimizing SQL 优化SQL (page 308) When a SQL query is designed or modified to take advantage of subquery factoring, there are some not-so-subtle changes that may take place when the...2012-05-14 22:19:57 · 106 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 10.2.2 Testing Over Multiple Executions
Testing Over Multiple Executions 测试多个执行 (page 312) What would happen if each query were run multiple times simultaneously from several differentdatabase sessions? Using a modified versio...2012-05-24 00:41:39 · 97 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter10.2.3 Testing the Effects of Query Changes
Testing the Effects of Query Changes 测试查询改变的效果 (page 315) Even as data does not remain static, SQL is not always static. Sometimes requirements change, so code must be modified. What if...2012-06-13 22:59:58 · 85 阅读 · 0 评论 -
《Pro Oracle SQL》 10.2.4 Seizing Other Optimization Opportunities
10.2.4 Seizing Other Optimization Opportunities 掌握其他的优化机会 There are other opportunities where subquery factoring may be used to your advantage. If you are working on applications that were...原创 2012-07-03 23:31:57 · 214 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 10.2.5 Applying Subquery Factoring to PL/SQL
Applying Subquery Factoring to PL/SQL 在PL/SQL中运用子查询分解 Even PL/SQL can present golden opportunities for optimization using subquery factoring. Something that most of us have done at one tim...2012-07-04 23:19:45 · 140 阅读 · 0 评论 -
《Pro Oracle SQL》10.3 Recursive Subqueries
Recursive Subqueries 递归子查询 New to Oracle 11.2 is recursive subquery factoring(RSF for the remainder of this chapter). As you can probably guess, the ANSI name for this feature is recu...2012-07-06 00:30:37 · 134 阅读 · 0 评论