 |
 |
Archives of the TeradataForum
Message Posted: Mon, 12 Aug 2003 @ 01:40:01 GMT
| 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
| |
