Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Jan 2012 @ 09:25:22 GMT


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


Subj:   Re: Improving the performance of a minus query
 
From:   Wadhwa, Vivek

Dear Sravan,

I hope you need all these columns in select statement. If it is so then you can try out one thing create volatile table with on commit preserve rows and take the data from both tables with below SELECT and filter.

After that you can try out something and if possible do mention the proper primary index as per the data you have.

hope it would resolve your issue..

Vivek



     
  <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: 27 Dec 2016