Oracle 19.26
I'm moving a database from being partitioned using custom code to using Oracle partitioning.
The monthly processing that inserts into this table loops through daily records and creates individual records at the rate of about 600,000 per day, and this is taking about 3 times as long as it used to, so I've run some tests.
An insert (as select * from …) that takes 48 seconds into our old individual table now takes 121 seconds into a partitioned table with comparable structure.
Elsewhere there was some advice to make the indexes GLOBAL to speed up inserts, but this doesn't seem to improve things, and would have adverse performance impacts elsewhere.
So I guess my question is just whether anyone has any tricks to speed this up? Or whether anyone knows this performance hit has been remediated in later versions of the DB?