Archives of the TeradataForum
Message Posted: Wed, 18 Oct 2000 @ 11:37:02 GMT
There are a couple of methods we use. One is an old tried and true NCR solution, not pretty, but effective. By adding a meaningless column to the dimension tables and using syntax like below, you can 'force' the product join of the smaller tables.
AND (T.Meaningless_column = P.meaningless_column
We have also had great success using derived tables to fill out the key and join to the fact table.
Lastly, per the documentation in NCR manuals (and our own testing), we do not collect statistics on the primary indexes of tables with > 1000 rows/amp. Your mileage may vary.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|