Archives of the TeradataForum

Message Posted: Thu, 11 Jan 2001 @ 18:01:54 GMT

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

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

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