Archives of the TeradataForum
Message Posted: Thu, 11 Jan 2001 @ 18:01:54 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|