Archives of the TeradataForum
Message Posted: Fri, 20 Feb 2004 @ 17:07:26 GMT
Thank you for the explain. It looks like it does not take advantage of the "is null" condition on the large table and builds the product join on the full tables, which is something you should avoid by all means. There are a few counts in the explain which I don't understand. For example, how 54,587,480 rows from Step 4 ("estimated with high confidence") relate to the fresh table row count you mentioned (5,461,246). It might be worth reporting this case to your NCR rep, especially if you are using one of the recent releases.
In the meantime you will of course need another solution. Perhaps you could use alternatives suggested by Mirjam and Henry or tell us what your purpose is so that people can generate more ideas, if necessary.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|