Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: wizofoz2k@yahoo.com.au (Nuno Souto)
Newsgroups: comp.databases.oracle.server
Subject: Re: design question, use of partitioned tables?
Date: 8 Aug 2003 00:17:24 -0700
Organization: http://groups.google.com/
Lines: 19
Message-ID: <73e20c6c.0308072317.4ee02566@posting.google.com>
References: <bgo51g$q4in4$1@uni-berlin.de> <73e20c6c.0308051646.1de34a10@posting.google.com> <bgqhgl$qssm6$1@uni-berlin.de> <3f30dd4c$0$10356$afc38c87@news.optusnet.com.au> <bgqr98$rlcs6$1@uni-berlin.de> <3f311672$0$10360$afc38c87@news.optusnet.com.au> <bgr86c$rmr97$1@uni-berlin.de> <73e20c6c.0308061627.659bf696@posting.google.com> <bgt878$r2t9n$1@uni-berlin.de>
NNTP-Posting-Host: 139.130.103.136
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060327045 17333 127.0.0.1 (8 Aug 2003 07:17:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2003 07:17:25 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240079

Manuela Mueller <mueller_m@fiz-chemie.de> wrote in message news:<bgt878$r2t9n$1@uni-berlin.de>...

> Answers embedded

Ah yes, I forgot.  If you really want top speed,
try also *with* LOGGING enabled!  Not ARCHIVE log,
just no NOLOGGING option anywhere in create table.

In my system and because I have very fast redo log
writing, this resulted in the least time to create
20K very large rows: under 1 minute.

There you go: one example where NOLOGGING may actually
be slower than not using it...


Cheers
Nuno Souto
wizofoz2k@yahoo.com.au.nospam