 |
 |
Archives of the TeradataForum
Message Posted: Fri, 13 Aug 2004 @ 20:40:48 GMT
| Subj: | | Re: UNION And INSERT INTO |
| |
| From: | | Anantaraman, Kumaran (K.) |
Victor wrote :
| | An easy and reliable way to tell would be to create a MULTISET table and compare the run times. I am not aware of any UNION specific
exceptions in checks for duplicates with SET tables. If the check will be done, the test will give you an idea of the overhead in your particular
case. | |
Wouldn't it be nice, if the explain displayed these additional choices the optimizer made?
Same issue with the 'fastpaths'. Under some circumstances, optimizer decides to use some fastpaths. But these are not identified in the
explains. I put in a request to PAC that explains should explicitly show them.
| |
