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 - 09:31:55 CDT
