Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Mar 2009 @ 21:34:52 GMT


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


Subj:   Re: Data access using views
 
From:   Michael Larkins

madhu das:

Not sure if much more detail is required. Teradata does not read the data out of a table, put it into spool and then select from it - no additional spool overhead required.

If you where to do the following:

     EXPLAIN sel columns from tablename

or

     EXPLAIN sel columns from viewname /* assumes view of columns & rows */

there is no difference in the output to the point that the view name does not appear anywhere in the output from the EXPLAIN

so if the original select would use an index the view would use the index doing the same select.


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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