2 - filter("AA"."ITEM_CODE"=:B1)
3 - access("AA"."HOSPITAL_ID"=:B1 AND "AA"."SERIAL_NO"=:B2)
4 - filter(ROWNUM<2)
6 - access("BS_ITEM"."ITEM_CODE"=:B1)
7 - filter(ROWNUM<2)
9 - access("BS_MEDI"."MEDI_CODE"=:B1)
11 - access("A"."HOSPITAL_ID"="B"."HOSPITAL_ID"(+) AND "A"."SERIAL_FEE"="B"."SERIAL_FEE"(+) AND
"A"."SERIAL_NO"="B"."SERIAL_NO"(+) AND "A"."FEE_BATCH"="B"."FEE_BATCH"(+))
14 - filter("C"."SERIAL_NO"='25735455' AND "C"."HOSPITAL_ID"='4307210003' AND
"C"."VALID_FLAG"='1')
15 - access("C"."ACCOUNT_ID"=16905170)
16 - filter("A"."VALID_FLAG"='1')
17 - access("A"."HOSPITAL_ID"='4307210003' AND "A"."SERIAL_NO"='25735455')
19 - access("D"."ACCOUNT_ID"(+)=16905170 AND "D"."AUDIT_PHASE"(+)='1' AND
"A"."SERIAL_FEE"="D"."SERIAL_FEE"(+))
filter(TO_NUMBER("D"."AUDIT_STAFF_ID"(+))=2103 AND "D"."SERIAL_FEE"(+)<>0 AND
"D"."AUDIT_PHASE"(+)='1' AND "A"."SERIAL_FEE"="D"."SERIAL_FEE"(+))
22 - filter("SERIAL_FEE"<>0 AND "VALID_FLAG"='1')
23 - access("B"."HOSPITAL_ID"='4307210003' AND "B"."SERIAL_NO"='25735455')
乱用Oracle Hint造成性能问题案例二(4)
内容版权声明:除非注明,否则皆为本站原创文章。
转载注明出处:https://www.heiqu.com/b3405948fb1ee73b5173d625b2f2bd95.html