Archives of the TeradataForum
Message Posted: Wed, 18 Oct 2000 @ 11:03:36 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|