Archives of the TeradataForum

Message Posted: Wed, 08 Feb 2006 @ 18:27:50 GMT

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

We force dynamic partition elimination by equijoining the big PPI table to a calendar table and filtering on the calendar table.

     select * from bigtable a, calendartable b
     where a.da_trans=b.da_calendar
       and b.da_calendar between begindate and enddate;

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