Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.



     
  <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: 15 Jun 2023