Re: Time to create index

From: HansF <News.Hans_at_telus.net>
Date: Fri, 17 Jun 2005 20:20:44 GMT
Message-Id: <pan.2005.06.17.20.23.46.333929@telus.net>

On Fri, 17 Jun 2005 21:51:42 +0200, Jaap W. van Dijk interested us by writing:

> On Thu, 16 Jun 2005 19:53:07 +0200, "Matthias Hoys"
> <idmwarpzone_NOSPAM__at_yahoo.com> wrote:
>
>

>>
>>If you have multiple processors, building the index with the PARALLEL option 
>>can drastically improve performance ... 
>>

> And for the OP's information: it can also reduce performance if al the
> data is on one disk.

Or the CPUs are near 100% anyway.

-- 
Hans Forbrich

Received on Fri Jun 17 2005 - 15:20:44 CDT