Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Parsercpu time very high
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016