Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Dec 2009 @ 21:18:10 GMT


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


Subj:   Re: Problem using join index.
 
From:   Mohommod.Khan

You collect Stat same way you do on a table but instead of Table name you refer to your JI. Try this:

     COLLECT STAT  INDEX (CCCP_KEY) ON LOANS_RETAIL_EXPSR;

I have got the JI working for your view after I added a row ID from the Left Table (,AK.ROWID AS AK_ROW) on your JI. I am not sure if it is the calculated field that was causing the issue. However I can confirm JI is working using /coming through the view and Joins both the Inner and Outer inside the view.

I am in V12.

HTH!


Thanks and happy holidays!



     
  <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