Archives of the TeradataForum
Message Posted: Tue, 28 Sep 1999 @ 21:22:12 GMT
I think that using that NCR tool or other you would know how much memory and I/O is using a specific query at running time, and you will track the query execution to see his memory and I/O consume, but I don't think a possible way to estimate the time or memory need to run a complete query. According with your mail I think that you are trying to classify every query prior to send that (or intercept the query) and, in case of a short query run it, and in case of a large query for example, delay that to the night. The only way to estimate the time for each query is running a explain prior to send it, but I don't think you will believe in the time that explain will give you.
Just Track every query,
Kenneth Stiglich M
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|