Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Feb 2011 @ 12:37:08 GMT


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


Subj:   Optimser behaviour question from TD virgin!
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, February 23, 2011 06:24 -->

Hi

Scenario: We have an aggregate table (call it Agg1) with Fact and Dimension data.

Our TD architect is proposing to create a dimension model by creating views to separate out Facts (Call it F1) and Dimensions (Call them D1, D2 and D3) from this table. I would rather not discuss WHY questions!!

My concern is that any Query using view F1, D1, D2 and D3 will perform multiple read accesses to the same base (Agg1).

My question is: Will TD optimiser figure out same base (Agg1) table is accessed and hence perform a single disk read?



     
  <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