Archives of the TeradataForum

Message Posted: Wed, 28 Aug 2014 @ 01:22:55 GMT

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

Hi,

Can you please confirm the following things as TD version 14.10 optimizer thinks different way when object use coint is enabled on system.

What is the DB version?

Is the Object Usage logging enabled on the system? You can verify using below query and look for the Objectusage flag is "T"(i.e True).

     Select * from dbc.dbqlrules.

What is the DDL for the table :- RPT_SPEC_WEIGHT ?

What kind of data stored in the column A11.PRODUCT_GN_NBR and data type.

Regards

Pinal Patel

     11) We do an all-AMPs JOIN step from Spool 3 (Last Use) by way of the
          hash value of "BAKTHRO.P in view RPT_SPEC_WEIGHT.PRODUCT_GN_NBR =
          '2874.80469 '" with an additional condition of (
          "A11.PRODUCT_GN_NBR = '2874.80469 '"), which is joined to Spool 21
          (Last Use) by way of an all-rows scan.  Spool 3 and Spool 21 are
          left outer joined using a product join, with condition(s) used for
          non-matching on left table ("PRODUCT_GN_NBR = '2874.80469 '"),
          with a join condition of ("PRODUCT_GN_NBR = PRODUCT_GN_NBR").  The
          result goes into Spool 18 (all_amps), which is built locally on
          the AMPs.  The size of Spool 18 is estimated with low confidence
          to be 33 rows (495 bytes).  The estimated time for this step is
          0.02 seconds.

Thanks,

Pinal Patel
Teradata DBA

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