Archives of the TeradataForum
Message Posted: Wed, 01 Dec 2004 @ 17:54:21 GMT
Sometimes in the explain plan of some SQL we see ("1=1") condition when it is doing the product join. We do not see this condition in all product joins.
I will appreciate if somebody explains me in what circumstances optimizer uses ("1=1") condition?
Having this condition in the explain is bad?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|