sql觀察
一個sql執行計劃的改變
一，簡介
1，需要執行的sql如下，其中llu.id 這個引數是可變的，根據配置的變化sql會變化
2，GV_INV_LOTLOCATIONUOM 的自連線，他有127713260條記錄
3，當llu.id這個引數有150個引數時，執行計劃如下
SELECT t.id AS docId, o.*
FROM GV_INV_LOTLOCATIONUOM o,
(SELECT *
FROM GV_INV_LOTLOCATIONUOM llu
WHERE llu.id IN (:1,
:2.......150)) t
WHERE o.domain_Id = t.domain_Id
AND o.org_id = t.org_id
AND o.warehouse_id = t.warehouse_id
AND o.customer_id = t.customer_id
AND o.location_id = :43
AND o.uom_id = t.uom_id
AND o.sku_id = t.sku_id
AND o.traceCode IS NULL
AND o.lotHeader_id || '_' = t.lotHeader_id || '_'
AND o.inboundtime || '_' = t.inboundtime || '_'
AND o.fixCreatedTime || '_' = t.fixCreatedTime || '_'
AND o.fixExpiredTime || '_' = t.fixExpiredTime || '_'
AND o.fixStatus_id || '_' = t.fixStatus_id || '_'
AND o.lotAtt01 || '_' = t.lotAtt01 || '_'
AND o.lotAtt02 || '_' = t.lotAtt02 || '_'
AND o.lotAtt03 || '_' = t.lotAtt03 || '_'
AND o.lotAtt04 || '_' = t.lotAtt04 || '_'
AND o.lotAtt05 || '_' = t.lotAtt05 || '_'
AND o.lotAtt06 || '_' = t.lotAtt06 || '_'
Plan Hash Value : 1874416940
-----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 572 | 249 | 00:00:03 |
| 1 | NESTED LOOPS | | 1 | 572 | 249 | 00:00:03 |
| 2 | PARTITION HASH ALL | | 65 | 18590 | 54 | 00:00:01 |
| * 3 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 54 | 00:00:01 |
| * 4 | INDEX RANGE SCAN | IDX_INVLLU_LOCATION_ID | 65 | | 17 | 00:00:01 |
| 5 | PARTITION HASH ITERATOR | | 1 | 286 | 3 | 00:00:01 |
| * 6 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 1 | 286 | 3 | 00:00:01 |
| * 7 | INDEX RANGE SCAN | IDX_UNION_LOTLOCATIONUOM | 1 | | 2 | 00:00:01 |
-----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 3 - filter("O"."TRACECODE" IS NULL)
* 4 - access("O"."LOCATION_ID"=4922418)
* 6 - filter(("LLU"."ID"=45977555 OR "LLU"."ID"=47458234 OR "LLU"."ID"=49189599 OR "LLU"."ID"=49781785 OR "LLU"."ID"=51977373 OR "LLU"."ID"=52038166 OR "LLU"."ID"=52147738 OR "LLU"."ID"=52161640 OR
."CUSTOMER_ID"="LLU"."CUSTOMER_ID" AND TO_CHAR("O"."LOTHEADER_ID")||'_'=TO_CHAR("LLU"."LOTHEADER_ID")||'_' AND
INTERNAL_FUNCTION("O"."INBOUNDTIME")||'_'=INTERNAL_FUNCTION("LLU"."INBOUNDTIME")||'_' AND INTERNAL_FUNCTION("O"."FIXCREATEDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXCREATEDTIME")||'_' AND
INTERNAL_FUNCTION("O"."FIXEXPIREDTIME")||'_'=INTE)
* 7 - access("O"."UOM_ID"="LLU"."UOM_ID" AND "O"."SKU_ID"="LLU"."SKU_ID")
注意
4，rows=65的計算方式
17:33:56 sys@WMS>select 127713260/1941639 from dual;
127713260/1941639
-----------------
65.7760068
17:56:18 sys@WMS>select count(*) from wms.GV_INV_LOTLOCATIONUOM o where o.location_id = 4922418
17:56:21 2 ;
COUNT(*)
----------
367116
顯然資料庫已o表做驅動表走location id 來做巢狀迴圈是不對的。
5，如果走llu.id的方式，因為id是主鍵，所以有多少引數，就有多少rows，計算的rows是150，cbo沒有選擇這個執行方式
在加了hint /*+ leading(t) */ 後出現如下執行計劃，走的是hash 連線
最好的執行計劃是，以t做驅動表走，巢狀連線。
Plan Hash Value : 2390386484
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 572 | 282 | 00:00:04 |
| * 1 | HASH JOIN | | 1 | 572 | 282 | 00:00:04 |
| 2 | INLIST ITERATOR | | | | | |
| 3 | TABLE ACCESS BY GLOBAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 150 | 42900 | 228 | 00:00:03 |
| * 4 | INDEX UNIQUE SCAN | SYS_C0013482 | 150 | | 153 | 00:00:02 |
| 5 | PARTITION HASH ALL | | 65 | 18590 | 54 | 00:00:01 |
| * 6 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 54 | 00:00:01 |
| * 7 | INDEX RANGE SCAN | IDX_INVLLU_LOCATION_ID | 65 | | 17 | 00:00:01 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 1 - access("O"."DOMAIN_ID"="LLU"."DOMAIN_ID" AND "O"."ORG_ID"="LLU"."ORG_ID" AND "O"."WAREHOUSE_ID"="LLU"."WAREHOUSE_ID" AND "O"."CUSTOMER_ID"="LLU"."CUSTOMER_ID" AND "O"."UOM_ID"="LLU"."UOM_ID"
AND "O"."SKU_ID"="LLU"."SKU_ID" AND TO_CHAR("O"."LOTHEADER_ID")||'_'=TO_CHAR("LLU"."LOTHEADER_ID")||'_' AND INTERNAL_FUNCTION("O"."INBOUNDTIME")||'_'=INTERNAL_FUNCTION("LLU"."INBOUNDTIME")||'_' AND
INTERNAL_FUNCTION("O"."FIXCREATEDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXCREATEDTIME")||'_' AND INTERNAL_FUNCTION("O"."FIXEXPIREDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXEXPIREDTIME")||'_' AND
TO_CHAR("O"."FIXSTATUS_ID")||'_'=TO_CHAR("LLU"."FIXSTATUS_ID")||'_' AND "O"."LOTATT01"||'_'="LLU"."LOTATT01"||'_' AND "O"."LOTATT02"||'_'="LLU"."LOTATT02"||'_' AND
"O"."LOTATT03"||'_'="LLU"."LOTATT03"||'_' AND "O"."LOTATT04"||'_'="LLU"."LOTATT04"||'_' AND "O"."LOTATT05"||'_'="LLU"."LOTATT05"||'_' AND "O"."LOTATT06"||'_'="LLU"."LOTATT06"||'_')
* 4 - access("LLU"."ID"=45977555 OR "LLU"."ID"=47458234 OR "LLU"."ID"=49189599 OR "LLU"."ID"=49781785 OR "LLU"."ID"=51977373 OR "LLU"."ID"=52038166 OR "LLU"."ID"=52147738 OR "LLU"."ID"=52161640 OR
ID"=590027057 OR "LLU"."ID"=596508187 OR "LLU"."ID"=597871307 OR "LLU"."ID"=599239467)
* 6 - filter("O"."TRACECODE" IS NULL)
* 7 - access("O"."LOCATION_ID"=4922418)
Plan Hash Value : 2390386484
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 572 | 155 | 00:00:02 |
| * 1 | HASH JOIN | | 1 | 572 | 155 | 00:00:02 |
| 2 | INLIST ITERATOR | | | | | |
| 3 | TABLE ACCESS BY GLOBAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 101 | 00:00:02 |
| * 4 | INDEX UNIQUE SCAN | SYS_C0013482 | 65 | | 68 | 00:00:01 |
| 5 | PARTITION HASH ALL | | 65 | 18590 | 54 | 00:00:01 |
| * 6 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 54 | 00:00:01 |
| * 7 | INDEX RANGE SCAN | IDX_INVLLU_LOCATION_ID | 65 | | 17 | 00:00:01 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 1 - access("O"."DOMAIN_ID"="LLU"."DOMAIN_ID" AND "O"."ORG_ID"="LLU"."ORG_ID" AND "O"."WAREHOUSE_ID"="LLU"."WAREHOUSE_ID" AND "O"."CUSTOMER_ID"="LLU"."CUSTOMER_ID" AND "O"."UOM_ID"="LLU"."UOM_ID"
AND "O"."SKU_ID"="LLU"."SKU_ID" AND TO_CHAR("O"."LOTHEADER_ID")||'_'=TO_CHAR("LLU"."LOTHEADER_ID")||'_' AND INTERNAL_FUNCTION("O"."INBOUNDTIME")||'_'=INTERNAL_FUNCTION("LLU"."INBOUNDTIME")||'_' AND
INTERNAL_FUNCTION("O"."FIXCREATEDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXCREATEDTIME")||'_' AND INTERNAL_FUNCTION("O"."FIXEXPIREDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXEXPIREDTIME")||'_' AND
TO_CHAR("O"."FIXSTATUS_ID")||'_'=TO_CHAR("LLU"."FIXSTATUS_ID")||'_' AND "O"."LOTATT01"||'_'="LLU"."LOTATT01"||'_' AND "O"."LOTATT02"||'_'="LLU"."LOTATT02"||'_' AND
"O"."LOTATT03"||'_'="LLU"."LOTATT03"||'_' AND "O"."LOTATT04"||'_'="LLU"."LOTATT04"||'_' AND "O"."LOTATT05"||'_'="LLU"."LOTATT05"||'_' AND "O"."LOTATT06"||'_'="LLU"."LOTATT06"||'_')
* 4 - access("LLU"."ID"=49189599 OR "LLU"."ID"=52038166 OR "LLU"."ID"=52147738 OR "LLU"."ID"=54005775 OR "LLU"."ID"=60104178 OR "LLU"."ID"=60163482 OR "LLU"."ID"=64023775 OR "LLU"."ID"=64042444 OR
"LLU"."ID"=64104666 OR "LLU"."ID"=64227729 OR "LLU"."ID"=66883555 OR "LLU"."ID"=69884257 OR "LLU"."ID"=69884277 OR "LLU"."ID"=69884491 OR "LLU"."ID"=70059387 OR "LLU"."ID"=71321605 OR
"LLU"."ID"=71843147 OR "LLU"."ID"=73872181 OR "LLU"."ID"=81936569 OR "LLU"."ID"=82059984 OR "LLU"."ID"=83977036 OR "LLU"."ID"=85308742 OR "LLU"."ID"=85464607 OR "LLU"."ID"=85580297 OR
"LLU"."ID"=85673052 OR "LLU"."ID"=85699670 OR "LLU"."ID"=85850963 OR "LLU"."ID"=85851392 OR "LLU"."ID"=85852479 OR "LLU"."ID"=86564725 OR "LLU"."ID"=100305127 OR "LLU"."ID"=160517367 OR
"LLU"."ID"=183898597 OR "LLU"."ID"=246089447 OR "LLU"."ID"=246325737 OR "LLU"."ID"=254965527 OR "LLU"."ID"=277559697 OR "LLU"."ID"=277559787 OR "LLU"."ID"=324798797 OR "LLU"."ID"=455024707 OR
"LLU"."ID"=462167737 OR "LLU"."ID"=467542007 OR "LLU"."ID"=472188727 OR "LLU"."ID"=473934937 OR "LLU"."ID"=482567407 OR "LLU"."ID"=484889477 OR "LLU"."ID"=493426267 OR "LLU"."ID"=496272327 OR
"LLU"."ID"=506452577 OR "LLU"."ID"=516402677 OR "LLU"."ID"=516547247 OR "LLU"."ID"=521305887 OR "LLU"."ID"=522943547 OR "LLU"."ID"=531291017 OR "LLU"."ID"=532816517 OR "LLU"."ID"=536431347 OR
"LLU"."ID"=536981557 OR "LLU"."ID"=540285967 OR "LLU"."ID"=550883567 OR "LLU"."ID"=565054857 OR "LLU"."ID"=573476197 OR "LLU"."ID"=579825607 OR "LLU"."ID"=585416367 OR "LLU"."ID"=590027057 OR
"LLU"."ID"=597871307)
* 6 - filter("O"."TRACECODE" IS NULL)
* 7 - access("O"."LOCATION_ID"=4922418)
一，簡介
1，需要執行的sql如下，其中llu.id 這個引數是可變的，根據配置的變化sql會變化
2，GV_INV_LOTLOCATIONUOM 的自連線，他有127713260條記錄
3，當llu.id這個引數有150個引數時，執行計劃如下
SELECT t.id AS docId, o.*
FROM GV_INV_LOTLOCATIONUOM o,
(SELECT *
FROM GV_INV_LOTLOCATIONUOM llu
WHERE llu.id IN (:1,
:2.......150)) t
WHERE o.domain_Id = t.domain_Id
AND o.org_id = t.org_id
AND o.warehouse_id = t.warehouse_id
AND o.customer_id = t.customer_id
AND o.location_id = :43
AND o.uom_id = t.uom_id
AND o.sku_id = t.sku_id
AND o.traceCode IS NULL
AND o.lotHeader_id || '_' = t.lotHeader_id || '_'
AND o.inboundtime || '_' = t.inboundtime || '_'
AND o.fixCreatedTime || '_' = t.fixCreatedTime || '_'
AND o.fixExpiredTime || '_' = t.fixExpiredTime || '_'
AND o.fixStatus_id || '_' = t.fixStatus_id || '_'
AND o.lotAtt01 || '_' = t.lotAtt01 || '_'
AND o.lotAtt02 || '_' = t.lotAtt02 || '_'
AND o.lotAtt03 || '_' = t.lotAtt03 || '_'
AND o.lotAtt04 || '_' = t.lotAtt04 || '_'
AND o.lotAtt05 || '_' = t.lotAtt05 || '_'
AND o.lotAtt06 || '_' = t.lotAtt06 || '_'
Plan Hash Value : 1874416940
-----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 572 | 249 | 00:00:03 |
| 1 | NESTED LOOPS | | 1 | 572 | 249 | 00:00:03 |
| 2 | PARTITION HASH ALL | | 65 | 18590 | 54 | 00:00:01 |
| * 3 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 54 | 00:00:01 |
| * 4 | INDEX RANGE SCAN | IDX_INVLLU_LOCATION_ID | 65 | | 17 | 00:00:01 |
| 5 | PARTITION HASH ITERATOR | | 1 | 286 | 3 | 00:00:01 |
| * 6 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 1 | 286 | 3 | 00:00:01 |
| * 7 | INDEX RANGE SCAN | IDX_UNION_LOTLOCATIONUOM | 1 | | 2 | 00:00:01 |
-----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 3 - filter("O"."TRACECODE" IS NULL)
* 4 - access("O"."LOCATION_ID"=4922418)
* 6 - filter(("LLU"."ID"=45977555 OR "LLU"."ID"=47458234 OR "LLU"."ID"=49189599 OR "LLU"."ID"=49781785 OR "LLU"."ID"=51977373 OR "LLU"."ID"=52038166 OR "LLU"."ID"=52147738 OR "LLU"."ID"=52161640 OR
."CUSTOMER_ID"="LLU"."CUSTOMER_ID" AND TO_CHAR("O"."LOTHEADER_ID")||'_'=TO_CHAR("LLU"."LOTHEADER_ID")||'_' AND
INTERNAL_FUNCTION("O"."INBOUNDTIME")||'_'=INTERNAL_FUNCTION("LLU"."INBOUNDTIME")||'_' AND INTERNAL_FUNCTION("O"."FIXCREATEDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXCREATEDTIME")||'_' AND
INTERNAL_FUNCTION("O"."FIXEXPIREDTIME")||'_'=INTE)
* 7 - access("O"."UOM_ID"="LLU"."UOM_ID" AND "O"."SKU_ID"="LLU"."SKU_ID")
注意
4，rows=65的計算方式
17:33:56 sys@WMS>select 127713260/1941639 from dual;
127713260/1941639
-----------------
65.7760068
17:56:18 sys@WMS>select count(*) from wms.GV_INV_LOTLOCATIONUOM o where o.location_id = 4922418
17:56:21 2 ;
COUNT(*)
----------
367116
顯然資料庫已o表做驅動表走location id 來做巢狀迴圈是不對的。
5，如果走llu.id的方式，因為id是主鍵，所以有多少引數，就有多少rows，計算的rows是150，cbo沒有選擇這個執行方式
在加了hint /*+ leading(t) */ 後出現如下執行計劃，走的是hash 連線
最好的執行計劃是，以t做驅動表走，巢狀連線。
Plan Hash Value : 2390386484
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 572 | 282 | 00:00:04 |
| * 1 | HASH JOIN | | 1 | 572 | 282 | 00:00:04 |
| 2 | INLIST ITERATOR | | | | | |
| 3 | TABLE ACCESS BY GLOBAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 150 | 42900 | 228 | 00:00:03 |
| * 4 | INDEX UNIQUE SCAN | SYS_C0013482 | 150 | | 153 | 00:00:02 |
| 5 | PARTITION HASH ALL | | 65 | 18590 | 54 | 00:00:01 |
| * 6 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 54 | 00:00:01 |
| * 7 | INDEX RANGE SCAN | IDX_INVLLU_LOCATION_ID | 65 | | 17 | 00:00:01 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 1 - access("O"."DOMAIN_ID"="LLU"."DOMAIN_ID" AND "O"."ORG_ID"="LLU"."ORG_ID" AND "O"."WAREHOUSE_ID"="LLU"."WAREHOUSE_ID" AND "O"."CUSTOMER_ID"="LLU"."CUSTOMER_ID" AND "O"."UOM_ID"="LLU"."UOM_ID"
AND "O"."SKU_ID"="LLU"."SKU_ID" AND TO_CHAR("O"."LOTHEADER_ID")||'_'=TO_CHAR("LLU"."LOTHEADER_ID")||'_' AND INTERNAL_FUNCTION("O"."INBOUNDTIME")||'_'=INTERNAL_FUNCTION("LLU"."INBOUNDTIME")||'_' AND
INTERNAL_FUNCTION("O"."FIXCREATEDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXCREATEDTIME")||'_' AND INTERNAL_FUNCTION("O"."FIXEXPIREDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXEXPIREDTIME")||'_' AND
TO_CHAR("O"."FIXSTATUS_ID")||'_'=TO_CHAR("LLU"."FIXSTATUS_ID")||'_' AND "O"."LOTATT01"||'_'="LLU"."LOTATT01"||'_' AND "O"."LOTATT02"||'_'="LLU"."LOTATT02"||'_' AND
"O"."LOTATT03"||'_'="LLU"."LOTATT03"||'_' AND "O"."LOTATT04"||'_'="LLU"."LOTATT04"||'_' AND "O"."LOTATT05"||'_'="LLU"."LOTATT05"||'_' AND "O"."LOTATT06"||'_'="LLU"."LOTATT06"||'_')
* 4 - access("LLU"."ID"=45977555 OR "LLU"."ID"=47458234 OR "LLU"."ID"=49189599 OR "LLU"."ID"=49781785 OR "LLU"."ID"=51977373 OR "LLU"."ID"=52038166 OR "LLU"."ID"=52147738 OR "LLU"."ID"=52161640 OR
ID"=590027057 OR "LLU"."ID"=596508187 OR "LLU"."ID"=597871307 OR "LLU"."ID"=599239467)
* 6 - filter("O"."TRACECODE" IS NULL)
* 7 - access("O"."LOCATION_ID"=4922418)
Plan Hash Value : 2390386484
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 572 | 155 | 00:00:02 |
| * 1 | HASH JOIN | | 1 | 572 | 155 | 00:00:02 |
| 2 | INLIST ITERATOR | | | | | |
| 3 | TABLE ACCESS BY GLOBAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 101 | 00:00:02 |
| * 4 | INDEX UNIQUE SCAN | SYS_C0013482 | 65 | | 68 | 00:00:01 |
| 5 | PARTITION HASH ALL | | 65 | 18590 | 54 | 00:00:01 |
| * 6 | TABLE ACCESS BY LOCAL INDEX ROWID | GV_INV_LOTLOCATIONUOM | 65 | 18590 | 54 | 00:00:01 |
| * 7 | INDEX RANGE SCAN | IDX_INVLLU_LOCATION_ID | 65 | | 17 | 00:00:01 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 1 - access("O"."DOMAIN_ID"="LLU"."DOMAIN_ID" AND "O"."ORG_ID"="LLU"."ORG_ID" AND "O"."WAREHOUSE_ID"="LLU"."WAREHOUSE_ID" AND "O"."CUSTOMER_ID"="LLU"."CUSTOMER_ID" AND "O"."UOM_ID"="LLU"."UOM_ID"
AND "O"."SKU_ID"="LLU"."SKU_ID" AND TO_CHAR("O"."LOTHEADER_ID")||'_'=TO_CHAR("LLU"."LOTHEADER_ID")||'_' AND INTERNAL_FUNCTION("O"."INBOUNDTIME")||'_'=INTERNAL_FUNCTION("LLU"."INBOUNDTIME")||'_' AND
INTERNAL_FUNCTION("O"."FIXCREATEDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXCREATEDTIME")||'_' AND INTERNAL_FUNCTION("O"."FIXEXPIREDTIME")||'_'=INTERNAL_FUNCTION("LLU"."FIXEXPIREDTIME")||'_' AND
TO_CHAR("O"."FIXSTATUS_ID")||'_'=TO_CHAR("LLU"."FIXSTATUS_ID")||'_' AND "O"."LOTATT01"||'_'="LLU"."LOTATT01"||'_' AND "O"."LOTATT02"||'_'="LLU"."LOTATT02"||'_' AND
"O"."LOTATT03"||'_'="LLU"."LOTATT03"||'_' AND "O"."LOTATT04"||'_'="LLU"."LOTATT04"||'_' AND "O"."LOTATT05"||'_'="LLU"."LOTATT05"||'_' AND "O"."LOTATT06"||'_'="LLU"."LOTATT06"||'_')
* 4 - access("LLU"."ID"=49189599 OR "LLU"."ID"=52038166 OR "LLU"."ID"=52147738 OR "LLU"."ID"=54005775 OR "LLU"."ID"=60104178 OR "LLU"."ID"=60163482 OR "LLU"."ID"=64023775 OR "LLU"."ID"=64042444 OR
"LLU"."ID"=64104666 OR "LLU"."ID"=64227729 OR "LLU"."ID"=66883555 OR "LLU"."ID"=69884257 OR "LLU"."ID"=69884277 OR "LLU"."ID"=69884491 OR "LLU"."ID"=70059387 OR "LLU"."ID"=71321605 OR
"LLU"."ID"=71843147 OR "LLU"."ID"=73872181 OR "LLU"."ID"=81936569 OR "LLU"."ID"=82059984 OR "LLU"."ID"=83977036 OR "LLU"."ID"=85308742 OR "LLU"."ID"=85464607 OR "LLU"."ID"=85580297 OR
"LLU"."ID"=85673052 OR "LLU"."ID"=85699670 OR "LLU"."ID"=85850963 OR "LLU"."ID"=85851392 OR "LLU"."ID"=85852479 OR "LLU"."ID"=86564725 OR "LLU"."ID"=100305127 OR "LLU"."ID"=160517367 OR
"LLU"."ID"=183898597 OR "LLU"."ID"=246089447 OR "LLU"."ID"=246325737 OR "LLU"."ID"=254965527 OR "LLU"."ID"=277559697 OR "LLU"."ID"=277559787 OR "LLU"."ID"=324798797 OR "LLU"."ID"=455024707 OR
"LLU"."ID"=462167737 OR "LLU"."ID"=467542007 OR "LLU"."ID"=472188727 OR "LLU"."ID"=473934937 OR "LLU"."ID"=482567407 OR "LLU"."ID"=484889477 OR "LLU"."ID"=493426267 OR "LLU"."ID"=496272327 OR
"LLU"."ID"=506452577 OR "LLU"."ID"=516402677 OR "LLU"."ID"=516547247 OR "LLU"."ID"=521305887 OR "LLU"."ID"=522943547 OR "LLU"."ID"=531291017 OR "LLU"."ID"=532816517 OR "LLU"."ID"=536431347 OR
"LLU"."ID"=536981557 OR "LLU"."ID"=540285967 OR "LLU"."ID"=550883567 OR "LLU"."ID"=565054857 OR "LLU"."ID"=573476197 OR "LLU"."ID"=579825607 OR "LLU"."ID"=585416367 OR "LLU"."ID"=590027057 OR
"LLU"."ID"=597871307)
* 6 - filter("O"."TRACECODE" IS NULL)
* 7 - access("O"."LOCATION_ID"=4922418)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29108064/viewspace-2140975/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 使用SQL TRACE和TKPROF觀察SQL語句執行結果SQL
- 觀察者模式-將訊息通知給觀察者模式
- 觀察和思考
- 觀察者模式模式
- PHP觀察者模式PHP模式
- Unity——觀察者模式Unity模式
- 觀察者模式（2）模式
- Java 觀察者模式Java模式
- JS 觀察者模式JS模式
- RxJS 簡介：可觀察物件、觀察者與操作符JS物件
- PHP-觀察者模式PHP模式
- PHP 之觀察者模式PHP模式
- 大話--觀察者模式模式
- redux與觀察者模式Redux模式
- 小白觀察：開源永存
- 觀察者模式介紹模式
- 重構 - 觀察者模式模式
- 觀察者模式（ObserverPattern）模式Server
- observer-觀察者模式Server模式
- JavaObserverPattern(觀察者模式)JavaServer模式
- swift 屬性觀察器Swift
- C# 觀察者模式.C#模式
- 18_觀察者模式模式
- 進擊的觀察者模式模式
- 設計模式----觀察者模式設計模式
- 設計模式 —— 觀察者模式設計模式
- 設計模式（觀察者模式）設計模式
- 設計模式——觀察者模式設計模式
- 行為型：觀察者模式模式
- ListView中的觀察者模式View模式
- 設計模式-觀察者模式設計模式
- innblock 工具| InnoDB page觀察利器BloC
- Observable - 觀察者模式的理解模式
- 觀察者模式的總結模式
- UITableview navbar漸變觀察者UIView
- Android之觀察者模式Android模式
- reactive streams與觀察者模式React模式
- 設計模式_觀察者模式設計模式