Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Oct 2002 @ 21:30:05 GMT


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


Subj:   Re: Insert getting Stuck
 
From:   Thomas Stanek

Dara,

Is it possible that your data contains many rows (many thousands) for each day, store combination? This could be the problem. That is because for every row with the same day/store value, the DBMS is checking to ensure that each row is unique.

Try running the same query and either:

Define the table as 'MultiSet', which will tell the DBMS to bypass the unique row check. Or Change the primary index to include the ProductID.

If, as I am assuming, your stores have thousands of items, this could very well be the problem. Let us know if this helps.


Regards,

Thomas F. Stanek
TFS Consulting
www.tfsconsulting.com



     
  <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