Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Star Schema
From:   John Street


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


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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023