Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Join Index on Multiple Tables
 
From:   Claybourne Barrineau

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016