Archives of the TeradataForum

Message Posted: Thu, 16 May 2002 @ 16:42:28 GMT

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

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.

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