Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 18 Feb 2003 @ 08:53:30 GMT

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

Subj:   Re: INSERT/SELECT out of one table into two
From:   David Wellman


On the "very quick load", it is the load (of the target table) which is quick and not the read (of the source tables). If you look at the explain of the MSR (how about that for old-fashioned?) you'll see that the two reads are done sequentially.

The optimiser will apply the same logic in your "one into two" example below.

You won't get sync scan on a single query because that requires two or more separate queries. If you ran the two INS/SEL requests as separate requests then you may get sync scan. Note that the two reads of the source table (steps % and 6.2) are "eligible for sync scan". Also, I think that although the optimiser will mark the steps as eligible for sync scan it is the file system (i.e. at each AMP) which makes the decision as to whether or not the sync scan occurs.



  <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: 28 Jun 2020