Skip to Main Content

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 an Table optimally designed for many parallel DML queries (INSERT/UPDATE)

Michael KöpperFeb 14 2025

I would like to create a table in an Oracle 19c DB (on premise) that is optimally designed for many parallel DML queries (INSERT/UPDATE).
What do I have to pay attention to?
Does partitioning help, with different tablespaces?
How must sequences be created or should sequences be omitted?
How should indices be created?
...

Comments
Post Details
Added on Feb 14 2025
17 comments
386 views