Archives of the TeradataForum

Message Posted: Thu, 09 Feb 2006 @ 14:07:31 GMT

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

Hello,

According to the PPI Orange Book (release V2R5.x, V2R6.0, and V2R6.1), product join partition elimination needs an equality-join on the partitioning column to another table, quote:

"Dynamic partition elimination (DPE) for product joins can occur when there is an equality constraint between the partitioning column of one table and a column of another table or spool".

Regarding the Date-optimization; at Partners 2005 I got the impression, that it was ready be "put in", but I'm not sure whether it's in R6.1.

Maybe someone from NCR would comment?

In the meantime, we have, in selected cases, used the following strategy:

Generate code to generate a macro with the code wanted.

Run the code to generate the macro in BTEQ via .RUN

Execute the generated macro "statically" in BTEQ.

This way the use of the tables in the macro can be seen in the dictionary. (I don't like self-generating code that I can't see in the dictionary!)

E.g.

     EXEC   Ma_GenCode_ToGenMacro; (this write code-lines to table WPt_DynSql
     using the Date-function, which then generates Ma_WantedCode with
     date-literals):

     .FORMAT OFF
     .EXPORT DATA   FILE=DYNSQL;

     SELECT SqlKode (FORMAT 'X(255)')
       FROM WPt_DynSql
      ORDER BY Linie;

     .EXPORT RESET;

     .RUN FILE=DYNSQL;

     EXEC    Ma_WantedCode;

Regards,

Ole Dunweber
Coop Nordic

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