Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Jul 2006 @ 11:48:28 GMT


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


Subj:   Re: Impact of Join index
 
From:   Mohommod.Khan

You should drop the Join index rebuild each time you load/delete from the tables. Also before you do that, you will need to collect stat on both of the tables that you join on. You will need to collect stat on the indices in this case col1 after you are done creating your join index and over all do an explain of your query and make sure your newly created JI is being used properly. Hope this helps.


Mohommod Khan
Bull Services



     
  <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