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!

why is my indexing taking so long?

77046Oct 10 2005 — edited Oct 10 2005

why would indexing a table with 8 000 000 rows take over 2hours? what are parameters and issues that impact on index creation speed? our database has a sort_area_size of 128000, could this be an the reason?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2005

Added on Oct 10 2005

#general-database-discussions

5 comments

354 views