Re: Index creation taking too long

Lisa,

Make sure that your index is getting created on a seperate disk from where your actual table is stored (to avoid disk contention). I can not say one way or the other about the paging.

SCott

Lisa Lewis 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 - 16:41:51 CDT