Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Mar 2004 @ 15:49:42 GMT


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


Subj:   Re: NOT IN Alternatives
 
From:   Fuller, Joe

Hi Craig,

If you are running V2R5 you can collect statistics on COLUMN(BRANCH_ID,STATUS) and see if that makes a difference however I suspect that it may not. I tested similar queries on some pretty large tables in our DWH and found the same type of explain, however the confidence level for rows was high. Interesting!


Joe Fuller



     
  <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