Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 15:22:08 GMT


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


Subj:   Re: Is there an equivalent of DUAL in Teradata
 
From:   Michael Larkins

Victor:

Your statement is true only when the SELECT references only literal(s) while using a Set operator. However, I would have to wonder why anyone would do that when using searching for specific literal values using a WHERE clause is so much more efficent. It uses less SPOOL space and less processing power to find what is being requested (no merge processing required)

So based on efficiency, back to my original (and correct) statement, if you use a literal and any column from any table while performing a UNION, MINUS, EXCEPT or INTERSECT - the FROM is optional.


Sincerely,

Michael Larkins
Certified Teradata Master



     
  <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