Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2002 @ 19:13:13 GMT
| Subj: || || Re: Erratic results via Business Objects |
| From: || || John Hall |
I don't see anything that is obviously wrong. There is one thing I would note just in case: In the past, there were problems with
RowHash Match Scans - but that has been fixed for a long time (circa V2R3). Are you running on an old version? If there's a question along
this line, you should check with NCR.
When I've encountered this kind of problem in the past, I've generally found that the data in my underlying tables wasn't stable and was
actually being changed while the query was running (or between runs). Are you sure that your tables are stable?
The LOCKING FOR ACCESS statements that appear in the EXPLAIN allows for dirty reads. If there's any question about the stability of your
data, you might try running the query without the LOCKING FOR ACCESS's.