Archives of the TeradataForum
Message Posted: Wed, 20 Feb 2008 @ 09:36:52 GMT
| Subj: || || Re: Query randomly running for long time |
| From: || || OmerAl |
The statistics are running fine. Besides, the key table is transaction keys so we keep archiving it on a daily basis and so we have only like
half a mil rows to be joined with another half a mil on 8 columns. But like today, query finished in less than three minutes. Is it possible that
the table gets a lock or something when collect statistics are running?