Re: Index creation taking too long

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_at_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
>
Received on Tue Jul 07 1998 - 19:09:13 CDT