 |
 |
Archives of the TeradataForum
Message Posted: Wed, 21 Jul 2004 @ 15:43:41 GMT
| Subj: | | Re: Impact of Failed Queries |
| |
| From: | | Victor Sokovin |
| | Not only the PE but other components too consume resources for failed queries. e.g. duplicate row are found when doing a merge at the bynet
from all amps. | |
INSERT ... SELECT statements sometimes fail only in the INSERT phase. For example, when you have a SUM in the SELECT, and the aggregated values
do not fit into the target table for some rows. Resources will be consumed during the query and the rollback.
Victor
| |
