Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2005 @ 17:24:55 GMT

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

Hi Madhukar,

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.

Cheers,

Dave

Ward Analytics Ltd: Information in motion
www.ward-analytics.com

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