Hi Laurenz, > On 18. Nov, 2020, at 13:02, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: > > I personally hope that we will never have global indexes. > I am not looking forward to helping customers with the problems that > they create (long duration of ATTACH/DETACH PARTITION, index fragmentation). +1. Experience shows that global index in Oracle lead to problems when dropping a partition. rebuilding an index, or other such nice administrative stuff, often leading to unnecessarily long downtimes. Cheers, Paul