2013-12-27一次关于子查询的优化 - 数据库编程

=:B1)
6 - access("CR"."QUESTION_ID"=:B1)
7 - filter("V"."VERSION_ID"=:B1)
9 - access("T"."TAG_ID"="TQ"."TAG_ID")
11 - access("TQ"."QUESTION_ID"=:B1)
14 - access("U"."USER_ID"=:B1)
17 - access("M"."QUESTION_ID"=:B1)
19 - access("CQW"."PROCESS_INS_ID"="BRTT"."CUR_PROCESS_INS_ID")
21 - access("CQ"."ID"=:B1)
23 - access("CQW"."QUESTION_ID"=:B1)

24 - filter("BRTT"."TRANS_ACTOR_ID"='N00251.sz')
25 - filter("RN_">20)
26 - filter(ROWNUM<=30)
28 - filter(ROWNUM<=30)
29 - access("ITEM_1"="T2"."ID")
32 - access("CQW"."PROCESS_INS_ID"="BRTT"."CUR_PROCESS_INS_ID")
33 - filter("BRTT"."TRANS_ACTOR_ID"='N00251.sz')
35 - access("CQ"."ID"="CQW"."QUESTION_ID")
36 - filter("T2"."STATE"<>(-1))

2013-12-27一次关于子查询的优化(三)