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

From: Reinhard Wahl <wahl_at_zv.fhg.de>
Date: Wed, 28 Apr 1999 12:00:31 +0200
Message-ID: <3726DC3F.B1D952A8@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 - 05:00:31 CDT