How can I make this SQL stmt more efficient?

I have the following SQL statement:

UPDATE ALODETAIL A SET DIM_7 = '-1' WHERE DIM_7 = '1' AND NOT EXISTS
(SELECT LOAN FROM ALODETAIL WHERE DIM_7= '1' AND VOUCHER_TYPE IN
('CC','CD','CE') AND LOAN = A.LOAN)

AND NOT EXISTS
(SELECT LOAN FROM ALOLOAN WHERE DIM_3 = '3' AND LOAN = A.LOAN)
It executes quickly if there only a few 100 records in ALODETAIL with a DIM_7 = '1', but takes forever for larger recordsets.

Can someone help me fine tune it? I'm using ORcale 8.0.5 if that matters.

Thanks

Mitch Abaza

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 08:18:44 CST