Archives of the TeradataForum
Message Posted: Sun, 17 Jun 2001 @ 15:07:31 GMT
Although the explain identifies the number of rows, the optimiser decides to copy a table across the nodes before this is known. That decision is based on collected statistics, the index and whether the join condition in your view matches the index precisely.
Make sure you have collected statistics on the smaller tables after indexing, or creating secondary indexes which exactly match the join condition of your view.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|