Performance tuning

General

Performance tuning

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

3 REPLIES
N/A

Re: Performance tuning

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

N/A

Re: Performance tuning

Glass,

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

Regards,

  Pavel.

N/A

Re: Performance tuning

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