faster 'delete from'?

From: P. Singleton <csa09_at_seq1.keele.ac.uk>
Date: 14 May 92 00:12:50 GMT
Message-ID: <2720_at_keele.keele.ac.uk>

Is there a faster way to delete all tuples from a table than 'delete from'? I saw something recently which said it gained speed by forfeiting rollbackability. I wasn't interested then; I am now.

  __   __    Paul Singleton (Mr)           JANET: paul_at_uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul_at_cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 621111 x7355
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082

Received on Thu May 14 1992 - 02:12:50 CEST

This message: [ Message body ]
Next message: kortikar_at_mipos2.intel.com: "Do you provide these things in SQL*FORMS forms (v3.0)"
Previous message: Neil Greene: "Re: Creating clusters after tables created"
Maybe reply: P. Singleton: "Re: faster 'delete from'?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message