PS: the query is doing an index range scan for the sub query and FFS for the parent.
I am forcing parallel DML also,i.e.,alter session force parallel DML.