Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create index nologging does not improve performance

Re: create index nologging does not improve performance

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 13 Apr 2002 08:57:09 GMT
Message-ID: <3cb7f170.683649@news.jaapwvandijk.myweb.nl>


I'm not sure what you mean, but from the Oracle 8.1.7 SQL Reference Manual, under CREATE INDEX:

'LOGGING/NOLOGGING: specifies that the creation of the index will be logged (LOGGING) or not logged (NOLOGGING) in the redo log file.'

It means also others things, but those are not the issue here.

Jaap.

On Fri, 12 Apr 2002 21:57:17 GMT, Daniel Morgan <damorgan_at_exesolutions.com> wrote:

>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 Sat Apr 13 2002 - 03:57:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US