Archives of the TeradataForum
Message Posted: Thu, 16 May 2002 @ 16:42:28 GMT
| Subj: || || Outer Join Query won't use matching Join Index |
| From: || || Timothy Hill |
When I create the following join index and then submit the exact same select statement as a query, it runs against the base tables and
not the join index. However, if I alter the query to use an inner join, it does run against the join index. What am I doing wrong? Why
won't the query in its original form, with a left join, run against an exactly matching join index??
create join index jix1 as
select (e.department_number, d.department_name),
(e.last_name, e.first_name, e.salary_amount)
from employee e LEFT JOIN department d
on e.department_number = d.department_number;
NB: Yes, this is a workshop query from the Advanced SQL course. However, it won't work the way the course manual implies it should.
Any help much appreciated. Cheers, Tim.