Archives of the TeradataForum
Message Posted: Mon, 26 Sep 2005 @ 17:24:55 GMT
How many amps on your system ? It may be that the number of comparisons is so small compared to a 'real' product join if it moved the small table.
One thing you might want to try as a test is:
- create a copy of your LOCATION table with a different PI (Description columns often give good distribution)
- collect stats on the new table, on both the PI and the LOC_ID column
- re-explain the query and see if the small table is moved.
- check the total estimated time and row count.
You may find that the estimated time is a lot bigger than the 3 minutes and 7 seconds shown below.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|