Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Jun 2006 @ 21:15:49 GMT


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


Subj:   Query State is PARSING
 
From:   KoscinskiB

Hello All,

We have a Cognos query that is in a state of PARSING on the Teradata database for as long as 20 minutes. The query is quite intense, it is a database view that returns 440+ columns. However, when we capture the actual SQL and run it in Queryman it only takes about a minute or two to run.

Is there anyway we can improve (or reduce) the amount of time it takes to PARSE the SQL? We have checked the DISABLE PARSING option on the ODBC driver.


Thanks,

Brian



     
  <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