Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create index parallel - slower than noparallel!

kfenneJan 30 2003 — edited Jan 30 2003

Hi!

We are running an 8.1.7.3 database on a two processor windows - based platform. The database is set to run in parallel excecution mode, and tests with simple SQL - queries shows significantly improved performance.
But when I try to create an index in parallel, and compare with the same index created with the noparallel - statement, the parallel creation time is longer than the noparallel one.
As the parallel statement excecutes, I can see from the v$pq_slave - view, that parallel processes clearly are beeing started.

Any suggestions on how to improve performance of parallel index creation?

Regards
Ketill

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 27 2003

Added on Jan 30 2003

#general-database-discussions

1 comment

487 views