SQL Performance (MOSC)

MOSC Banner

Delete statements performance slow

edited May 1, 2015 10:02AM in SQL Performance (MOSC) 4 commentsAnswered

I have a performance issue of the Delete statement

DELETE  FROM  CHESS_PROD.MPSFDET  WHERE  CCN  = :P02457  AND  MPS_REF  = :P03138  AND  MPS_REF_DOC  = :P02462  AND  MPS_REF_LINE  = :P02474;

-----------------------------------------------------------------------------

| Id  | Operation         | Name     | Rows  | Bytes | Cost (%CPU)| Time     |

------------------------------------------------------------------------------

|   0 | DELETE STATEMENT  |          |     1 |    55 |  4275   (1)| 00:00:52 |

|   1 |  DELETE           | MPSFDET  |       |       |            |          |

|*  2 |   INDEX RANGE SCAN| X_MPSFDT |     1 |    55 |  4275   (1)| 00:00:52 |

------------------------------------------------------------------------------

   2 - access("CCN"=:P02457 AND "MPS_REF"=:P03138 AND

              "MPS_REF_DOC"=:P02462 AND "MPS_REF_LINE"=:P02474)

       filter("MPS_REF_DOC"=:P02462 AND "MPS_REF_LINE"=:P02474 AND

              "MPS_REF"=:P03138)

Table structure:

CCN           

MPSFDET_MAS_LOC

ITEM          

REVISION      

MPS_DATE      

MPS_REF       

MPS_REF_DOC   

MPS_REF_LINE  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center