The reason that your insert is taking longer is that the five indexes have to be updated before the insert completes. Partitioning can greatly help in this case because instead of the insert happening in the entire table, only a small portion is considered. And if you use local indexes on that table, then only a small portion of the index, corresponding to that partition, will be affected as well. With 2 million new rows a day, this table can be an ideal candidate for partitioning.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.