Archives of the TeradataForum

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

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

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>>