Same query taking different CPU TIME, RESPONSE TIME

General
Enthusiast

Same query taking different CPU TIME, RESPONSE TIME

Hi 

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

Raj

2 REPLIES
Enthusiast

Re: Same query taking different CPU TIME, RESPONSE TIME

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.

Khurram
Enthusiast

Re: Same query taking different CPU TIME, RESPONSE TIME

Hi,

Did you have a look at the DBQL tables?

Cheers,

Raja