Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 28 Sep 1999 @ 21:22:12 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Query Management
From:   Kenneth Stiglich

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
Serv. Data WareHouse
Ingenieria de la Información

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023