Home -> Usenet -> c.d.o.tools -> 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_at_[64.94.198.252]> 





[Quoted] We have a table which has 7m rows



create unique index  ........ logging


[Quoted] [Quoted] 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 - 20:46:47 CEST












Original text of this message