Re: Generating Huge Table

From: as <none_at_asgmeail.com>
Date: Tue, 24 May 2005 06:59:05 +0800
Message-ID: <4292604a_3@rain.i-cable.com>

"Frank van Bortel" <frank.van.bortel_at_gmail.com> ??? news:d6spvg$ar3$1_at_news6.zwoll1.ov.home.nl ???...
> Sounds like an *excellent* case for the merge
> statement.
> And Thomas Kyte has some benchmarks on insert... exception
> vs merge (also on insert/update vs update/insert).
>
> I would call this a prime example of something you
> do *not* want to do in Java.
>
> --
> Regards,
> Frank van Bortel

By the way, is MERGE an Oracle specific extension to SQL? Is it available in MSSQL and MySQL? I need to make sure my app is portable. It looks like availability of MERGE affects the whole design. Received on Mon May 23 2005 - 17:59:05 CDT