Archives of the TeradataForum
Message Posted: Wed, 18 Oct 2000 @ 13:40:47 GMT
This is otherwise known as a 'superfluous join' and it can be a bad habit and can eventually backfire on you.
If you have statistics on all join columns the optimizer usually creates the best or at least one of the best plans.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|