Re: create index nologging does not improve performance

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Fri, 12 Apr 2002 21:57:17 GMT
Message-ID: <3CB7583C.298185C7@exesolutions.com>

No logging has nothing to do with what you are doing against the table.

Go to http://technet.oracle.com and learn what nologging is.

Daniel Morgan

Mike F wrote:

> We have a table which has 7m rows
>
> create unique index ........ logging
> Elapsed: 00:03:230.90
>
> create unique index ........ nologging
> Elapsed: 00:03:218.41
>
> create unique index .........nologging parallel (degree 2);
> Elapsed: 00:04:282.39
>
> Could somebody tell me why?
>
> Thanks
>
>
>
> --
> Sent by dbadba62 from hotmail within area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Fri Apr 12 2002 - 16:57:17 CDT