Archives of the TeradataForum

Message Posted: Thu, 30 Oct 2003 @ 10:27:12 GMT

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

<-- Anonymously Posted: Wednesday, October 29, 2003 17:21 -->

We are trying to find out the bad queries running on the system , for this we are using Larry Higa's ratio. i.e cputime * 1000 /diskio.

Queries that we got are using lot of string operations , such as concatenation, substring..etc.

Does the string operations or case statement cause to use more CPU?

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