All Forums Database
spkother 18 posts Joined 07/13
12 Sep 2014
Dynamic partition elimination

Hi,
 
  I am new to teradata.what is dynamic partitioning elimination when it is comes under picture.please clarify

Raja_KT 1246 posts Joined 07/09
12 Sep 2014

From TD docs:
Dynamic row partition elimination (DPE) is a form of partition elimination that cannot occur until data values in the tables are known in order to eliminate partitions: Teradata Database cannot determine the partitions to be eliminated until the plan is executed and the data is scanned. Because of this, dynamic partition elimination must be applied on the AMPs after query optimization has already taken place. You can also see " enhanced by dynamic partition elimination "
You read the documents:
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1142_111A/ch02.124.224.html
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details.012.099.html
Few notes : dynamic row partition elimination is not supported with merge join methods for multilevel partitioned tables

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

spkother 18 posts Joined 07/13
18 Sep 2014

Thanks for the info,still i am not clear can you give one example.When DPE will occur and when static partition elimination will occur.
Thanks in advance

Karam 75 posts Joined 07/09
24 Apr 2015

Dynamic row partition elimination improves performance when a partitioned table and a non partition table are joined by an equality condition on the partitioning column set of the partitioned table.
Following link shed detailed info on how it is used and performance advantages:
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details.012.099.html
 
 
C

You must sign in to leave a comment.