Archives of the TeradataForum
Message Posted: Fri, 08 Feb 2002 @ 12:11:21 GMT
I made the same experience in the past:
Logical equal but different written SQLs (where clause vs. inner join syntax) can result in different plans and usually one is much better (not always the where clause).
NCR says always the optimiser does query rewriting but in this area it seems to have some lacks.
Will this change in a future release?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|