Re: Updating while joining
Date: Tue, 18 Aug 2009 20:15:41 +1000
Saravanan <vsr.saravanan_at_gmail.com> writes:
> I am joining three tables a,b,c of which b and c are really large
> ( 20 million+ records). The join is running and in the mean time I am
> updating some rows in the table b and c. Will my join reflect the
> newly updated data in b and c?
> Will the join complete successfully?
The join should complete, but it will not show the updated data if the join started prior to the updates being committed.
Have a look at the oracle concepts manual on Oracle's read consistency model.
-- tcross (at) rapttech dot com dot auReceived on Tue Aug 18 2009 - 05:15:41 CDT