Re: Rollback question

From: I hate Spam <tbf_at_cn.stam.dk>
Date: Mon, 04 Feb 2002 23:29:30 +0100
Message-ID: <1o2u5ucejptboqqvs47j6kqrjcnpdqi49l@4ax.com>

On Sun, 03 Feb 2002 13:16:05 +0100, Artur Undebarrena <aundebarrena_at_ictnet.es> wrote:

>Hello.
>
>I need to tell to Oracle database that do not use the rollback SQL
>command to accelerate the delete command. I use databases in development
>process and I don't need to rollback the inserts, updates and deletes. I
>want to accelerate my sql queries and I think if I deactivate the
>rollback command I'll win in speed.

If you are deleting all rows in a table use trunc instead.

Yours Hans Erik Busk
tbf_at_cn.stam.dk Received on Mon Feb 04 2002 - 16:29:30 CST