Delete statements performance slow
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