On Sun, Apr 21, 2024 at 2:58 PM yudhi s <learnerdatabase99@xxxxxxxxx> wrote:
the partition drop from parent is taking longer as it scans all the partitions of the child table
Does the relevant supporting index exist on the child table?
the partition drop from parent is taking longer as it scans all the partitions of the child table