2012 年 11月 25 日随笔档案 - Coldest Winter

2012年11月25日

subquery unnesting、Subquery unnesting and View Merge

摘要：本文内容系转载，如有侵犯你的知识产权，烦请及时告知本人，本人将即刻停止侵权行为。参考网址：http://space.itpub.net/27064837/viewspace-746501 http://space.itpub.net/471666/viewspace-694608 http://jonathanlewis.wordpress.com/2008/02/17/pushing-predicates-2/ http://www.oraclefans.cn/forum/showtopic.jsp?rootid=6963 http://www.... 阅读全文

posted @ 2012-11-25 16:52 Coldest Winter 阅读(312) 评论(0) 推荐(0)

Difference between Nested & Correlated Subqueries

摘要：参考网址：http://sql-plsql.blogspot.com/2011/09/difference-nested-correlated-subquery.html http://www.java2s.com/Tutorial/Oracle/0040__Query-Select/WritingNestedSubqueries.htm http://www.java2s.com/Tutorial/Oracle/0040__Query-Select/WritingCorrelatedSubqueries.htm需要使用代理方可打开。一、嵌套子查询和关联子查询的区别... 阅读全文

posted @ 2012-11-25 09:12 Coldest Winter 阅读(405) 评论(0) 推荐(0)