Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2007 @ 16:07:12 GMT


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


Subj:   Explain Anomaly: Direct Query vs View
 
From:   Kamin Shah

All,

You may have already seen this and might know what causes this, so I am looking for help as to why this would happen. When I run an explain on ?select * from the view? I get a different explain than when I run it on the Select statement of the view. Any idea why this would happen?

I have a view which joins 15 tables and the view looks like the following (at a very high level):

     REPLACE VIEW as ViewName

     (
     Col1,
     Col2,
     .
     .
     .
     .
     ColN
     )
     AS
     SELECT
     A as Col1,
     B as Col2,
     .
     .
     .
     .
     Z as Col N
       From
     Table 1
     Inner join Table 2
     On conditions
     .
     .
     .
     .
     Inner join Table 15
     On Conditions;


     
  <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