Geez, I didn't know you could do that. Sheepishly,
Jared On Friday 27 December 2002 03:38, Larry Elkins wrote: > Someone asked in a back channel email if parallelism is used. The select > portion of the update statement uses parallelism (though the updates > themselves get serialized) through the use of an in-line join update (to > avoid the second sub-query commonly used to constrain the rows being > updated): > > Update (Select /*+ parallel hints */ .... > From a,b > Where a.key = b.key) > Set a.col1 = b.col1, > a.col2 = b.col2 > ..... > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Larry > > Elkins > > Sent: Thursday, December 26, 2002 6:09 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Row Migration > > > > > > Listers, > > > > 8.1.7.4 64 Bit Solaris > > > > Does row migration utilize DB File Sequential Reads on the table? Off the > > top of my head I would expect so, but I've never tested something > > like that > > before. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
