ITPub博客

首页 > Linux操作系统 > Linux操作系统 > What cause the big diffrence on the same sql ?

What cause the big diffrence on the same sql ?

原创 Linux操作系统 作者:flyerchen2000 时间:2011-05-09 15:47:22 0 删除 编辑
1.DELETE FROM PUB_QUEUE
WHERE
 ROWID = :B1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute    261      0.00       0.18          0        261       1093         261
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      261      0.00       0.18          0        261       1093         261

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: 29  (LSS)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  DELETE STATEMENT   MODE: CHOOSE
      0   DELETE OF 'PUB_QUEUE'
      0    TABLE ACCESS (BY USER ROWID) OF 'PUB_QUEUE' (TABLE)
               PARTITION:ROW LOCATION




2.DELETE FROM PUB_QUEUE
WHERE
 ROWID = :B1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute    511    253.46     248.94          2    6625899       3932         511
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      511    253.46     248.94          2    6625899       3932         511

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: 37  (LSS)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  DELETE STATEMENT   MODE: CHOOSE
      0   DELETE OF 'PUB_QUEUE'
      0    TABLE ACCESS   MODE: ANALYZED (BY USER ROWID) OF 'PUB_QUEUE'
               (TABLE) PARTITION:ROW LOCATION

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/3637/viewspace-694842/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-25

  • 博文量
    44
  • 访问量
    75515