From: u518615722@spawnkill.ip-mobilphone.net (Mike F) Sender: u518615722@spawnkill.ip-mobilphone.net Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools Subject: create index nologging does not improve performance Date: Fri, 12 Apr 2002 18:46:47 GMT Lines: 26 Message-ID: NNTP-Posting-Host: 64.94.198.252 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) - ur Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!feed.news.nacamar.de!news1.ip-mobilphone.net!news2.ip-mobilphone.net!u518615722@spawnkill.ip-mobilphone.net Xref: easynews comp.databases.oracle.server:142946 comp.databases.oracle.tools:50623 X-Received-Date: Fri, 12 Apr 2002 11:57:57 MST (news.easynews.com) 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