Archives of the TeradataForum
Message Posted: Wed, 16 Aug 2006 @ 08:46:06 GMT
Subj: | | Very Long Running Query |
|
From: | | Ferry, Craig |
I have a query that has been running for approximately 26 hours. Is there a way to tell how close it is to be completed?
We are unable to process other jobs on the system due to the table being locked.
I have tried raising the priority of the query about 9 hours ago but that doesn't seem to have helped. I also think we would not want to kill
the query to to rollback time.
Craig Ferry
Manager, Data Warehousing and Central Systems
WESCO Distribution, Inc.
|