Archives of the TeradataForum
Message Posted: Mon, 22 Jul 2013 @ 12:30:41 GMT
<-- Anonymously Posted: Monday, July 22, 2013 05:36 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|