Xref: alice comp.databases.oracle.server:24188
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news.alt.net!magpage.com!usenet
From: dshi@magpage.com (David Shi)
Newsgroups: comp.databases.oracle.server
Subject: Re: Index creation taking too long
Date: 8 Jul 1998 00:09:13 GMT
Lines: 23
Message-ID: <6nudb9$4q2$1@204.179.92.161>
References: <6ntbho$3th$1@usenet01.srv.cis.pitt.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.5/32.451

I would think few things can help:

- parallel
- nologging (which you did)
- temporary tablespace
- allocate sorting area in memory

David

On Tue, 7 Jul 1998 10:31:55 -0400, "Lisa Lewis" <lewis@med.pitt.edu> wrote:

>I am creating a non-unique index on a table with roughly 3 million entries.
>I am using the nologging option.  The index creation took 30 minutes...much
>longer than I had expected.  I am trying to determine why it took so long.
>I am currently the only user of this development database.  I am running on
>Solaris.  When I do a vmstat 5 5, I see that I am paging somewhat (pi=274
>po=200 roughly).  Is this bad?  What can I do to improve the speed of
>creating the index?  Any suggestions would be greatly appreciated!!!
>
>Lisa
>P.S.  Please respond by e-mail
>