Archives of the TeradataForum
Message Posted: Fri, 30 May 2003 @ 17:37:11 GMT
| 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...