Re: create index nologging does not improve performance
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Sat, 13 Apr 2002 10:48:05 +0100
Message-ID: <3cb7feb4$0$231$ed9e5944_at_reading.news.pipex.net>
Date: Sat, 13 Apr 2002 10:48:05 +0100
Message-ID: <3cb7feb4$0$231$ed9e5944_at_reading.news.pipex.net>
because you don't have a performance problem in the first place caused by the redo io?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.1018637208.1782989501_at_[64.94.198.252]...Received on Sat Apr 13 2002 - 11:48:05 CEST
> 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