Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 15 Apr 2015 @ 17:45:37 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023