PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1033925045
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows |
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 4321 |
| 1 | SORT GROUP BY | | 4321 |
| 2 | TABLE ACCESS BY GLOBAL INDEX ROWID| FINANCIAL_SALEBANK | 1936 |
| 3 | NESTED LOOPS | | 61936 |
|* 4 | TABLE ACCESS FULL | BASE_MAINAREA | 32 |
|* 5 | INDEX RANGE SCAN | FINANCIAL_SALEBANK_IDX3 | 1930 |
--------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - filter("M"."BANKID"<>'00001')
5 - access("M"."BANKID"="S"."BANKID" AND "S"."STATE"=0)
filter("S"."BANKID"<>'00001')
----------没有添加前----
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1535569777
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%C
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 4321 | 173K| 730
| 1 | SORT GROUP BY | | 4321 | 173K| 730
| 2 | NESTED LOOPS | | 123K| 4959K| 713
|* 3 | TABLE ACCESS FULL| BASE_MAINAREA | 32 | 576 | 3
|* 4 | INDEX RANGE SCAN | FINANCIAL_SALEBANK_IDX2 | 3871 | 89033 | 22
--------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - filter("M"."BANKID"<>'00001')
4 - access("M"."BANKID"="S"."BANKID")
filter("S"."BANKID"<>'00001')
刚刚写错了
是加了 AND S.STATE = 0 查询才会很慢的