Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 11:53:45 GMT


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


Subj:   How does it Do it??
 
From:   Tony Howe

If I have a query:

   "SELECT EMPID, PRODUCT, CLASS FROM VMDB.V_EMPLOYEE"  ===> vmdb.v_employee is a view

I run an EXPLAIN on it and the explain output will show me the underlying column name from the underlying table that's used in the view. In other words, the above view accesses table CPDWHA.EMPLOYEE which is what comes out on the explain instead of VMDB.V_EMPLOYEE along with column names EMP_ID for EMPID and PROD_CODE for PRODUCT and CLASS_CODE for CLASS. How does the explain tie these view column names back to the real table column names???? I would like to produce a cross reference listing that shows this very thing.


Hope I was able to get my question across.

Thanks, Tony.



     
  <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