Archives of the TeradataForum
Message Posted: Thu, 04 Jan 2001 @ 22:58:44 GMT
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.
Admin Comment: When last tried, the URL in this Post no longer functioned.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|