Inserting to a Multiset Table

Database
Enthusiast

Inserting to a Multiset Table

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?

Many Thanks,

Tags (1)
1 REPLY
Junior Contributor

Re: Inserting to a Multiset Table

Is the target table empty or populated?

What's the PI/partitioning of the target table?

How many rows in source and target?

Dieter