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.
| 
