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.