 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 May 2003 @ 15:12:38 GMT
| Subj: | | Re: Need help with Query |
| |
| From: | | Dieter Nöth |
Villeneuve Philippe wrote:
| | 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
| |
