Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Oct 2000 @ 11:04:18 GMT


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


Subj:   Re: Star Schema
 
From:   David Roth

Jaz,

You do not mention if you have secondary indexes and/or have collected statistics on the foreign key fields in the fact table? You might try this to give the optimizer information on both sides of the possible joins.

Dave

David W. Roth
Senior Consultant
NCR / Teradata Solutions Group



     
  <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