All Forums General
TD_Raj 50 posts Joined 05/10
11 Dec 2013
Same query taking different CPU TIME, RESPONSE TIME

I am running the same query in Teradata and everytime I am seeing changes in CPU Time and Response Time.
I have tried running the same query in same session as well as in different sessions.
Response Time I am calculating by (FIRST RESPONSE TIME - START TIME).
When I say different time I mean varying time and does not mean less time with subsequent execution if running in same session and more time if running each time in different session.
In the same session too , I am getting more time for subsequent runs.
Kindly suggest what can be the possible reasons for different response time every time I run the query.
Thanks is advance

M.Saeed Khurram 544 posts Joined 09/12
11 Dec 2013

Hi Raj,
The response and throughput depends upon a number of factors, at times you might have different workloads running, that might cause different response time for the same query.


Raja_KT 1246 posts Joined 07/09
12 Dec 2013

Did you have a look at the DBQL tables?

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.