Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Oct 2002 @ 13:26:29 GMT


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


Subj:   Re: Multiple Views of an Object and the Optimizer
 
From:   Doorey, Andrew ST

What the optomiser is doing is correct. There is no link between the two ViewDim views. You could have data in the multidim table like:

MultiDim
ColA      x1       x2
ColA1     purple   green
ColA2     .        .
ColA3     .        .
ColB      y1       y2
ColB1     tiger    elephant
ColB2     .        .
ColB3     .        .

If there is a row on the basefact table with colA=x1 colB=y2 then the row will be returned, even though there isn't a purple elephant row on the multidim table.



     
  <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