In an old Esri post, someone mentioned:
[When exporting a feature class, you can develop a workflow to] query in spatial index order, which would optimize created feature order, which should result in improved performance with every query. And if you're going to do that, then you should also optimize your coordinate reference to reduce storage and improve query performance.
https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082
Does a similar concept/technique exist for SDO_GEOMETRY?