hey pss,
In that case, It does not make use of the index:
I tried it , Here is the explain plan

DELETE ACC_PARTITION
NESTED LOOPS 167
VIEW VW_NSO_1 3
SORT UNIQUE 3
TABLE ACCESS FULL ACCOUNT_DELETE_HLP 1
TABLE ACCESS BY LOCAL INDEX ROWID ACC_PARTITION 2
INDEX RANGE SCAN HLP_LOC_IDX 1
DELETE STATEMENT 167
DELETE ACC_PARTITION
NESTED LOOPS 167
VIEW VW_NSO_1 3
SORT UNIQUE 3
TABLE ACCESS FULL ACCOUNT_DELETE_HLP 1
TABLE ACCESS BY LOCAL INDEX ROWID ACC_PARTITION 2
INDEX RANGE SCAN HLP_LOC_IDX 1


In the recent discussion, I was given to understand that with subquery's the index will not be used and It's better to use joins.

can you clarify
Badrinath