Re: Bypass generating redo and/or rollback information?

As far as I know, there's no way for DMLs.

To speed up insert, you can add /*+ append */ if you know its implication. Update is always expensive. I can't think of any way to speed it up. (Optimize the query in the where clause of your update if it's a complicated one)

Yong Huang
yhuang_at_indigopool.com

<ryanedley_at_my-deja.com> wrote in message news:8lscej$n3l$1_at_nnrp1.deja.com...
> Hello, I was wondering if anyone knows of a way
> to bypass redo logging and generating rollback
> for regular insert and update statements.
>
> I know the NOLOGGING clause can be used for
> CREATE statements, but I would like to do this
> for DML statements.
>
> Thanks,
> Ryan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT