Archives of the TeradataForum
Message Posted: Thu, 12 Aug 2004 @ 08:46:21 GMT
Taking an example of 2 SELECT statements combined by the UNION operator and being inserted into a table defined as CREATE SET.
The EXPLAIN will detail the elimination of duplicate rows in spool between the 2 SELECT statements.
My query to anyone who would know is whether this then removes the duplicate row checking process when the rows are inserted into the CREATE SET table? or would this step still take place because of the table definition.
The destination table would be empty and I'm aware there would be other ways of doing this. The query is purely to do with how the UNION and INSERT into CREATE SET table combine and whether the processing is clever enough to identify that duplicate row checks have already been performed within the UNION step.
Thanks in advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|