Re: Faster index creation

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 14 May 2008 21:03:40 GMT
Message-ID: <482b53ac$0$30640$834e42db@reader.greatnowhere.com>


On Wed, 14 May 2008 10:33:24 -0700, Mark D Powell wrote:

> I would set work area management policy to manual, set the largest
> practical sort_area_size possible and just run one index build at a
> time.

That wouldn't be advisable in case of Oracle 10.2. It has a new and improved sorting algorithm, specifically improved to use large memory areas and dynamic PGA memory.

-- 
http://mgogala.freehostia.com
Received on Wed May 14 2008 - 16:03:40 CDT

Original text of this message