------------------------
3 - filter(("D"."DATA_TYPE"=:DATA_TYPE AND "D"."DATA_DATE"=:DATA_DATE AND "D"."VALUE_FLAG"=0))
4 - filter("C"."COLLECT_ID"=TO_NUMBER(:COLLECT_ID))
5 - access("D"."MODEL_ID"="C"."MODEL_ID")
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "D"."MODEL_ID"[NUMBER,22], "D"."OBJ_ID"[NUMBER,22], "D"."OBJ_TYPE"[VARCHAR2,2],
"D"."DATA_TYPE"[VARCHAR2,2], "D"."DATA_DATE"[DATE,7], "D"."DATA_FROM_DATE"[DATE,7], "D"."DATA_TO_DATE"[DATE,7],
"D"."DATA_FLAG"[NUMBER,22]
2 - "D"."MODEL_ID"[NUMBER,22], "D"."OBJ_ID"[NUMBER,22], "D"."OBJ_TYPE"[VARCHAR2,2],
"D"."DATA_TYPE"[VARCHAR2,2], "D"."DATA_DATE"[DATE,7], "D"."DATA_FROM_DATE"[DATE,7], "D"."DATA_TO_DATE"[DATE,7],
"D"."DATA_FLAG"[NUMBER,22]
3 - "D"."MODEL_ID"[NUMBER,22], "D"."OBJ_ID"[NUMBER,22], "D"."OBJ_TYPE"[VARCHAR2,2],
"D"."DATA_TYPE"[VARCHAR2,2], "D"."DATA_DATE"[DATE,7], "D"."DATA_FROM_DATE"[DATE,7], "D"."DATA_TO_DATE"[DATE,7],
"D"."DATA_FLAG"[NUMBER,22]
5 - "C".ROWID[ROWID,10]
HASH_VALUE 54043712, child number 1
SELECT D.MODEL_ID, D.OBJ_ID, D.OBJ_TYPE, D.DATA_TYPE, D.DATA_DATE, D.DATA_FROM_DATE, D.DATA_TO_DATE,
D.DATA_FLAG FROM zbdba1 D, zbdba2 C WHERE D.MODEL_ID = C.MODEL_ID AND C.COLLECT_ID =
:COLLECT_ID AND D.DATA_DATE = :DATA_DATE AND D.DATA_TYPE = :DATA_TYPE AND D.VALUE_FLAG = 0
NOTE: cannot fetch plan for HASH_VALUE: 54043712, CHILD_NUMBER: 1
Please verify value of HASH_VALUE and CHILD_NUMBER;
It could also be that the plan is no longer in cursor cache (check v$sql_plan)
81 rows selected.
查看表行数：
SYS@zbdba>select num_rows,last_analyzed from dba_tables where table_name='zbdba1';
NUM_ROWS LAST_ANALYZE
---------- ------------
659764063 31-JUL-15
SYS@zbdba>select num_rows,last_analyzed from dba_tables where table_name='zbdba2';
NUM_ROWS LAST_ANALYZE
---------- ------------
76513 14-JUL-15
explan plan for 该sql查看执行计划：
SYS@zbdba>select * from table(dbms_xplan.display());
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 2057366878
----------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
----------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 3 | 183 | 11 (0)| 00:00:01 | | |
| 1 | TABLE ACCESS BY GLOBAL INDEX ROWID| zbdba1 | 1 | 51 | 4 (0)| 00:00:01 | ROWID | ROWID |
| 2 | NESTED LOOPS | | 3 | 183 | 11 (0)| 00:00:01 | | |
| 3 | TABLE ACCESS BY INDEX ROWID | zbdba2 | 2 | 20 | 4 (0)| 00:00:01 | | |
|* 4 | INDEX RANGE SCAN | IDX_zbdba2COLLECTFLAG | 2 | | 2 (0)| 00:00:01 | | |
|* 5 | INDEX RANGE SCAN | IDX_C_COLLECT_MD_001 | 1 | | 3 (0)| 00:00:01 | | |
----------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------ |