Archives of the TeradataForum

Message Posted: Wed, 18 Oct 2000 @ 11:37:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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
OR T.meaningless_column <> P.meaningless_column)
AND (T.meaningless_column = G.meaningless_column
OR T.Meaningless_column <> G.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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>