Xref: alice comp.databases.oracle.server:24153
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!portc02.blue.aol.com!pitt.edu!not-for-mail
From: "Lisa Lewis" <lewis@med.pitt.edu>
Newsgroups: comp.databases.oracle.server
Subject: Index creation taking too long
Date: Tue, 7 Jul 1998 10:31:55 -0400
Organization: University of Pittsburgh
Lines: 12
Message-ID: <6ntbho$3th$1@usenet01.srv.cis.pitt.edu>
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

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