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


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.


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