Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> create index nologging does not improve performance
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/newReceived on Fri Apr 12 2002 - 13:46:47 CDT