Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 13:05:58 GMT

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

<-- Anonymously Posted: Friday, September 29, 2006 08:58 -->

I made the columns in my table not null, recollected statistics and still have a low confidence on my explain.

     4) We do an all-AMPs JOIN step from dss_tables.b by way of a RowHash
        match scan with no residual conditions, which is joined to
        dss_tables.a by way of a RowHash match scan with no residual
        conditions.  dss_tables.b and dss_tables.a are joined using a
        merge join, with a join condition of ("(dss_tables.a.country_code
        = dss_tables.b.country_code) AND ((dss_tables.a.mfr_no =
        dss_tables.b.mfr_no) AND (dss_tables.a.generic_column =
        dss_tables.b.generic_column ))").  The result goes into Spool 1
        (group_amps), which is built locally on the AMPs.  The size of
        Spool 1 is estimated with low confidence to be 2,498,329 rows.
        The estimated time for this step is 1.27 seconds.

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