|
|
Archives of the TeradataForum
Message Posted: Fri, 05 Aug 2005 @ 08:56:55 GMT
Subj: | | Re: Optimizer and Transitive Property of Equality |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, August 04, 2005 23:59 -->
Deriving transitive closure conditions is independent of stats collection in the optimizer. Check the explain (the one before adding the extra
conditions) if the new derived conditions are missing (obviously, it should). Just wanted to make sure if optimizer is missing a good plan, even
if the conditions are derived internally.
| |