SQL> update VG_NUMBER_POOL_MOBILE set DCOUNT=233,HCOUNT=233,FINISHTIME=1353205788 where PNUM='13904000299';
1 row updated.
Elapsed: 00:00:00.01
Execution Plan
----------------------------------------------------------
Plan hash value: 1326068284
---------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------
| 0 | UPDATE STATEMENT | | 1 | 23 | 2 (0)| 00:00:01 |
| 1 | UPDATE | VG_NUMBER_POOL_MOBILE | | | | |
|* 2 | INDEX RANGE SCAN| INDEX_NUMBER_POOL_MOBILE_PNUM | 1 | 23 | 1 (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("PNUM"='13904000299')
SQL> select PNUM,FINISHTIME,HCOUNT,DCOUNT from VG_NUMBER_POOL_MOBILE where PNUM='13904000299';
PNUM FINISHTIME HCOUNT DCOUNT
--------------------- ---------- ---------- ----------
13904000299 1353205788 233 233
Elapsed: 00:00:00.00
Execution Plan
----------------------------------------------------------
Plan hash value: 1803719096
-------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 23 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| VG_NUMBER_POOL_MOBILE | 1 | 23 | 2 (0)| 00:00:01 |
|* 2 | INDEX RANGE SCAN | INDEX_NUMBER_POOL_MOBILE_PNUM | 1 | | 1 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("PNUM"='13904000299')