Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 May 2003 @ 17:37:11 GMT


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


Subj:   Re: Query In Dispatch without visible SQL
 
From:   McBride, Michael

Ok, I will tell you all this, the query was not in 'insert' mode, the perm space was not increasing (remained static) , and at no time did the row count (using locking for access) move above zero (0), the query was still running after 13 hours (when I finally aborted). The cpu skew was 90% . The query consumed an enormous amount of cpu. I changed the query (fixed a date comparison and removed a non-essential join) and it ran (completed) in two minutes.

The problem... well for one thing the substring was returning a date 'YYMMDD' and making a date compare thinking it was 1903 (I forgot to concatenate '20') to the front of the string. However, the date comparison should still have been valid, if only a century off. It should have returned with "no rows inserted' because 1903anyday is not > than '2003-04-28'. So I can't figure out what it (the query) was doing for all those cpu seconds???...

Anyway, thanks for all your interest...



     
  <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