- 最后登录
- 2014-10-17
- 在线时间
- 20 小时
- 威望
- 91
- 金钱
- 685
- 注册时间
- 2011-12-29
- 阅读权限
- 50
- 帖子
- 44
- 精华
- 2
- 积分
- 91
- UID
- 136
|
1#
发表于 2012-3-2 14:58:29
|
查看: 3844 |
回复: 1
update item535set fee=fee+to_number(:v_fee)
where region=:v_region and billcycle=:v_cycle and ratecycle=:v_ratecycle
andsubsid=to_number(:v_subsid) and acctid=to_number(:v_acctid)
and billnum=:v_billnum and itemtype=:v_itemtype and itemcode=:v_itemcode and
itemaddcode=:v_itemaddcode and partialitemseq=0 and feegroupid= :v_feegroupid
anditemflag=:v_itemflag and rownum=1 returning 1 into :v_retcode
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Operation |PHV/ObjectName | Rows | Bytes| Cost |
| UPDATESTATEMENT |------------- | | | 2 |
|UPDATE | | | | |
| COUNTSTOPKEY | | | | |
| PARTITION RANGE SINGLE | | | | |
| TABLE ACCESS BY LOCAL INDEXROW|ITEM533 | 1 | 200 | 2 |
| INDEX UNIQUESCAN |PK_BILLITEM533 | 1| | 1 |
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 2 3.20 17.89 1365 49730 14336 14166
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 3.20 17.89 1365 49730 14336 14166
this sql have acondition of “rownum=1”, so we think this sql should update only one recordeach time, but why the statistic show that this sql has been executed 2 timesbut have 14166 rows processed?
It is suspected 2rows processed, right? What does the “rows” here indicate? |
|