 |
 |
Archives of the TeradataForum
Message Posted: Wed, 06 Aug 2003 @ 13:36:25 GMT
| Subj: | | Re: Need help in understanding poor performance |
| |
| From: | | Dieter Noeth |
Chris Coffing wrote:
| | Since this is a temp table... You can create it as a Multi Set table instead of a SET table and it will run faster because it will
not have to check for duplication. | |
If he's running on V2R4+ and the target table is empty, there's no improvement in making it multiset: The result of a MINUS is
always DISTINCT, so the optimizer will skip duplicate row checks.
That's why i asked for more details ;-)
Dieter
| |
