Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 12 Aug 2003 @ 01:40:01 GMT


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


Subj:   Re: Piggy back
 
From:   Wayne Moran

If I understand your question correctly, the term "piggy back" is;

If you have 2 or my queries that are running against the same table with the same selection, the data base record is read and used by the first query. Then the same record is passed on to the second query and so on. This is a performance boost because multiple queries used the same record with only one I/O. The queries do not have to start at the same time. If one is running and a second one starts, it will use the records of the first query and then go back and get the missed records after the first query is done reading the table.

Wayne N. Moran



     
  <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