Preparing Delete Script

[prakashs43]

Hi friends ,

i am preparing delete script

if i pass quest_id's hard coded is this process going to execute in a faster way ....

DELETE FROM SCORE_SYN0406F WHERE grp_id > 1 and QUEST_ID IN ( SELECT QUEST_ID FROM VERSION_ITEM WHERE VERSION_ID = 28831 AND RESP_SCALE_ID = 1 ) AND POINT_NBR > 5 ;

and explain plan is
--------------------

DELETE STATEMENT Optimizer=CHOOSE (Cost=24 Card=6 Bytes=306)
DELETE OF SCORE_SYN0406F
NESTED LOOPS (Cost=24 Card=6 Bytes=306)
TABLE ACCESS (BY INDEX ROWID) OF VERSION_ITEM (Cost=22 Card=1 Bytes=12)
INDEX (RANGE SCAN) OF XIF127VERSION_ITEM (NON-UNIQUE) (Cost=3 Card=1)
INDEX (RANGE SCAN) OF SCORE_PK_SYN0406F (UNIQUE) (Cost=2 Card=598 Bytes=23322)


primary key is grp_id , quest_id and point_nbr ..