Archives of the TeradataForum
Message Posted: Wed, 18 Oct 2000 @ 11:37:02 GMT
| Subj: | | Re: Star Schema |
| |
| From: | | Steve Bracewell |
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.
| 
