All Forums General
sravan244 7 posts Joined 04/14
24 Jul 2014
Performance tuning

is there anyway we can see if particular execution step is going to finish in sometime in viewpoint or any other tool?

Glass 225 posts Joined 04/10
24 Jul 2014

Sravan,
You have the estimated processing time viewable in the explain tab of the running query, as far as 
'going to finish' , no.
If the query has run before and DBQL logging is enabled for the user then you can view historical runs in dbqlogtbl for the same to have an idea. The load on the system also needs to be considered.
 
Rglass

PaulEr 5 posts Joined 04/12
24 Jul 2014

Glass,
Just to be clear: this time is cost for Teradata optimizer and not estimated time of query execution.
 
Regards,
  Pavel.

Glass 225 posts Joined 04/10
26 Jul 2014

Sure, I agree.
the explain plan is your best indication of query efficiency. The estimated processing time (cost)for a particular step will give you an indication of how expensive a step may be and without historical runs of the query, is your only tool to estimate how long the query may actually run.(providing statistics are current) 
Rglass

You must sign in to leave a comment.