I have a piece of code that uses Group by and Qualify and am looking to insert the data into a Multiset Table. When I run the piece of code on its own it only takes about 1 minute or so to run but when I attempt to run as an Insert then it increases 10mins plus....?
How can I speed this up?
Is the target table empty or populated?
What's the PI/partitioning of the target table?
How many rows in source and target?