Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2002 @ 19:13:13 GMT


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


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.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023