Archives of the TeradataForum

Message Posted: Tue, 09 Apr 2013 @ 08:48:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, April 08, 2013 23:47 -->

Hi all,

I did some app development on Vr25 and then moved away. Now, I'm again starting on TD13.0. I remember that we calculated higa ratio on dbc.ampusage to check whether the query was okay or needed retuning.

Our DBA doesn't want to refresh dbc.ampusage and asks us to use dbc.Dbqlogtbl;

Is there a 'norm' like the higa ration -that you folks use to check whether a query is okay using dbqlogtbl? Is it okay to use the same ratio here too? Please let me know. I cant seem to get any good documentation on dbqlogtbl. Will be grateful for any pointers

	<Prev	Next>		<<First	<Prev	Next>	Last>>