Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 24 Apr 2013 @ 12:45:37 GMT


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


Subj:   Re: Tuning the Query to Better Performance
 
From:   Dieter Noeth

Anomy.Anom wrote:

  Could you suggest any performance can be improved on this query  


  Currently this query running average 1 min 15 seconds our users needed this to be run in less than 15 seconds  


  Up dated all stats but not much improvement.  


The first thing you should do is to check if DBQL stepinfo is enabled (otherwise ask your DBA) and then find out which step uses most resources and if there are any huge differences between estimated and actual CPU, IO and number of rows.

The SQL itself doesn't look that bad :-)


Dieter



     
  <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: 24 Jul 2020