Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 10:20:00 GMT

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

Hello All,

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?

Thanks.

Regards,

Omar Alvi

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