Archives of the TeradataForum
Message Posted: Tue, 14 Jan 2003 @ 22:20:05 GMT
I am guessing here, the explain explicitly states the join condition of ("Store_Key = Daily_Item_Sales.Store_Key").
How many rows are in Daily_Item_Sales? I am going to guess around 360M.
You query contains no filter or constraint. I would expect that you would get all rows in Daily_Item_Sales tables (360M?).
The product join is referring to the many-to-one join required from Daily_Item_Sales to store.
As for Jose's suggestion. If store remains un-constrained, I don't think an index will help. Daily_Item_Sales is being scanned. "3) We do an all-AMPs JOIN step from Spool 2 (Last Use) by way of an all-rows scan"
A scan is required, because you are retrieving ALL the rows.
I you filter the stores table and follow Jose's suggestion I think you will achieve better results.
BTW what is the primary index on the Daily_Item_Sales?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|