Archives of the TeradataForum

Message Posted: Wed, 18 Oct 2000 @ 11:03:36 GMT

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

Jaz,

Another option/method/suggestion would be to create a join index on the dimension tables so the join does not have to be performed each time (this of course uses up additional space) You would need to create the join index with a join criteria so if you have an additional column that is always the same on all dimension tables and have the same value (e.g. bytint = 1) then the join index can be created on that.

You then have to think of how the dimension tables are updated/refreshed as to if you want to drop and recreate the join index which I would imajen to be the best other than letting the system replicate the changes

Cheers

John
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited

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