Archives of the TeradataForum
Message Posted: Wed, 15 Apr 2015 @ 17:45:37 GMT
| Subj: || || Re: Concurrent Insert/Select into Partitioned Table |
| From: || || Walter, Todd |
If you know that they have all arrived, or some group have arrived, you can build a UNION for the source of the INSERT SELECT for the ones that
are available. The INSERT SELECT will then insert the whole result of the UNION in one insert process.
It sounds like the staging tables are fairly small though. When they are small, individual insert selects will run quite quickly and it will be
a similar time to get the job done if you just launch them when the data for that store is avalable and allow them to sequence through.