Explain plan displayed with wrong cardinality
Hey,
when i execute the SQL Statement
SELECT time_sheet_id
FROM tm_time_sheet_lines
WHERE work_item_type = 'TASK'
AND work_item_set_id = 30422
/
13270 Rows selected.
When i generate the Explain plan it is displaying the cardinlity as 6658 . (ROWS).
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 1822136991
-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 6658 | 53264 | 59 (0)| 00:00:01 |
|* 1 | TABLE ACCESS FULL| TM_TIME_SHEET_LINES | 6658 | 53264 | 59 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
1 - filter("WORK_ITEM_TYPE"='TASK')
Please advice me!!.
Cheers
Ramkannan.A
UOB - Singapore.