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.
The DELAY TIME is NULL.
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
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.