Oracle 连接因式分解(Join Factorization)(5)

1 - access("T1"."PROD_ID"="VIEW_JF"."PROD_ID")
  2 - filter("T1"."PROD_LIST_PRICE">1000)
  5 - access("T2"."CUST_ID"="T3"."CUST_ID")
  6 - filter("T3"."CUST_GENDER"='MALE')
  7 - access(ROWID=ROWID)
  9 - access("T3"."CUST_GENDER"='MALE')
  13 - access("T2"."CUST_ID"="T3"."CUST_ID")
  14 - filter("T3"."CUST_GENDER"='FEMALE')
  15 - access(ROWID=ROWID)
  17 - access("T3"."CUST_GENDER"='FEMALE')

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/1f55a25d95345ec37ee774c4c070c459.html