Archives of the TeradataForum

Message Posted: Mon, 22 Jul 2013 @ 12:30:41 GMT

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

<-- Anonymously Posted: Monday, July 22, 2013 05:36 -->

Hi All,

One of my ?views is running very slow as compared to a day or two before- though the underlying tables have the same number of rows. On Checking dbqlogtbl, I found that the Parsercpu time has shot up from 3.3- 4 seconds earlier to between 250 ? 400 seconds, though the ampcputime remains the same as before.

I have not changed the view definition?unable to comprehend why there is such a spurt in Parsercpu. Please let me know I we could do something about this.

Regards

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