 |
 |
Archives of the TeradataForum
Message Posted: Thu, 28 Jan 2010 @ 17:31:56 GMT
| Subj: | | Re: Workaround to avoid product join |
| |
| From: | | Victor Sokovin |
| | sorry for the delay. Thanks a lot for your inputs - I really appreciate. Unfortunately, I must say that the original product join query
has the best results in terms of performance among all you proposed and I tried myself. | |
Product join has the best performance? I guess we all are learning something new here every day.
A lot depends on the data, of course. Perhaps the pre-aggregation suggested by Dieter did not reduce the volumes much in your particular case?
The skew is another thing to check, as always.
Victor
| |
