Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Jan 2009 @ 14:21:43 GMT


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


Subj:   Optimizing the queries sourcing from Views
 
From:   Anomy Anom

<-- Anonymously Posted: Wed, 28 Jan 2009 14:16 -->

What could be the best way of optimizing the SQLs which source data from the views?

If TASM is implemented and the query falls in medium queue (execution time between 30 seconds to 20 minutes) but if such a query is based on a view instead then what ways could be used to reduce the execution times?



     
  <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