Is Index required ? what kind of index ?
Oracle : 10.2.0.3
Os : Linux
Number of rows in this table : 1884809
Hi All,
I would like to know if i create an index on this table would give any performance benift. If yes what kind of index i need to create ? Anyone can help me on this ? Thanks in advance.
Execution Plan
----------------------------------------------------------
Plan hash value: 1180540431
------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 52 | 10311 (1)| 00:02:04 |
| 1 | HASH UNIQUE | | 1 | 52 | 10311 (1)| 00:02:04 |
|* 2 | TABLE ACCESS FULL| SBN_NEWTON_MAPPER_METRICS | 1 | 52 | 10310 (1)| 00:02:04 |
------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("PROBEDATE"=TO_DATE('2010-12-20 23:24:22', 'yyyy-mm-dd hh24:mi:ss') AND
"MAPPER_LOT"='SBJZ171191' AND "MAPPER_WAFER_ID"='2')
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
48732 consistent gets
47180 physical reads
0 redo size
704 bytes sent via SQL*Net to client
492 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed