Hi,
We would like to understand where an alter table attach partition spend its
time.
to my understanding, explain doesnt do this.
for a BI job we have a partitionned table with 1800+ partitions.
the feeding process of this table leeds to detach and attach partitions.
attaching do take time, something like 12 seconds by partition.
We need to understand where that time is spent (check constraints or check
within the default partition or...)
So, how to ?
thanks,
regards,
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com