When I am trying to execute the below query, it is very slow(1 to 2 mins), but that not happens everytime, like once in 5 or 6 times.
FROM MQ_DPC_PKGS MDP,
WHERE MDP.DOC_NO = MDB.DOC_NO
AND MDP.BILL_NO = MDB.BILL_NO
AND MDB.BILL_NO = '303-00006116-13'
AND REC_TYPE = 'I'
AND NVL (MDP.DEL_IND, 'N') = 'N'
table MQ_DPC_PKGS is from remote DB. Help me to find out reason / solution.