 |
 |
Archives of the TeradataForum
Message Posted: Wed, 24 Apr 2013 @ 12:45:37 GMT
| 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
| |
