Archives of the TeradataForum
Message Posted: Tue, 19 Feb 2008 @ 10:20:00 GMT
We are facing this issue for the third time now in the past 2 weeks. There are two tables (A key table and a transactions table) that are joined in a query during our daily load process, and sometimes (randomly) the query keeps running for 3-4 hours. When we drop the "key" table and recreate it and it starts working. At this point also, if we run the same query when nothing is being loaded the query keeps running without any results. If this was a daily thing we could have understood but it happens one day and then will not happen for a week. One of the tables gets Fast Loaded and all the other jobs that use the key table run fine except this one. Any ideas?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|