|
Archives of the TeradataForumMessage Posted: Tue, 15 Oct 2002 @ 21:30:05 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||