Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 May 2003 @ 15:12:38 GMT


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


Subj:   Re: Need help with Query
 
From:   Dieter Nöth

Villeneuve Philippe wrote:

  Wouldn't it be better?  


  Select
Employee.Employee_Number,
Employee.Name,
Employee.Date_Of_Birth,
Employee.Department,
Employee.Date_of_last_review,
W_Review_Date.Pay_Rise_Given
From Employee,
(Select Employee_Number,Pay_Rise_Given
from Review_Date ) as W_Review_Date
where W_Review_Date.Employee_Number=Employee.Employee_Number
and W_Review_Date.Date_Of_Review=Employee.Date_of_last_review
 




There will be no gain, as it just selects all rows from review_date. Unless you're on V2R5 it may be even worse, because of materializing the derived table.


Dieter



     
  <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