Archives of the TeradataForum
Message Posted: Thu, 04 Jan 2001 @ 22:58:44 GMT
| Subj: | | Re: Union Conundrum |
| |
| From: | | Sam Sterling |
I hate to ask the obvious, but... Are statistics current?
You might want to include the query to look at the joins, in light of the statistics. It is possible that the sum of the answer
sets of the UNIONed answer sets is larger than you might think (it is possible (I'm not exactly sure how, though) that depending on
the join criteria you may get more rows in the UNIONed because more rows would qualify for each SELECT individually and be double
counted in the final answer set).
I'm definitely not the guru on arcane things that the optimizer might do. I'd have to beat this one into submission just like
you.
Sam Sterling
www.SSterling.com
Admin Comment: When last tried, the URL in this Post no longer functioned.
| 
