 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Jan 2001 @ 18:01:54 GMT
| Subj: | | Join Index on Multiple Tables |
| |
| From: | | Claybourne Barrineau |
V2R3
We are currently testing a Join Index solution for our Star Schema Datamart (1 fact, 6 dimensions.) Ultimately, I'd like to avoid all
run-time joins from the fact to the dimension tables via the optimizer always choosing the Join Index as the optimal path for resolution
(therefore, the longest it could take to resolve the user's query is the time is takes to do a full Join-Index scan plus the time it takes
to aggregate the result.) Our biggest problem has been the 16 column limitation of 'Field 2.' Has anyone else run into this problem, and,
if so, did you find any good work arounds?
Thanks,
Claybourne Barrineau
| |
