Re: Strange Performance Behavior on INSERT INTO SELECT statement...

From: Dave Cowden <cowden_at_earthlink.net>
Date: Wed, 28 Apr 1999 21:21:30 -0400
Message-ID: <7g8ccd$o4f$1@holly.prod.itd.earthlink.net>

Thanks for replying.

I though about that, and before I had tried the insert into, I had altered the table into NOLOGGING mode(see original "things I tried"): shouldnt that have
eliminated the ROLLBACK logging?

Reinhard Wahl wrote in message <3726DC3F.B1D952A8_at_zv.fhg.de>...
>Hi Dave,
>
>it's because a CREATE TABLE AS-Statement does not write any
>ROLLBACK-Information.
>If it works the rows are commited, if it doesn't the table does not
>exist.
>So it's pretty fast.
>But if you need to recover the database afterwards,
>I think the table is not recoverable, but you can repeat the statement.
>
>Hope this helps
>
>Reinhard
>
>----------------------------------------------------
>Please do not use my E-Mail address for advertising!
>----------------------------------------------------
> Hiermit widerspreche ich der Nutzung oder
> Uebermittlung meiner Daten fuer Werbezwecke
> oder fuer die Markt- oder Meinungsforschung
> gemaess Par. 28 Abs. 3 Bundesdatenschutzgesetz.
>----------------------------------------------------
Received on Wed Apr 28 1999 - 20:21:30 CDT