Re: create index nologging does not improve performance

Daniel Morgan 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

If you go to technet.oracle.com, you'll find that nologging has a whole lot to do with 'create index' which is what the poster is trying to improve...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."