Archives of the TeradataForum
Message Posted: Thu, 30 Oct 2003 @ 10:27:12 GMT
<-- 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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|