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 -> create index nologging does not improve performance

create index nologging does not improve performance

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Fri, 12 Apr 2002 18:46:47 GMT
Message-ID: <l.1018637208.1782989501@[64.94.198.252]>


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 - 13:46:47 CDT

Original text of this message

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