Terminology Static Partition (SP) columns: in DML/DDL involving multiple partitioning columns, the columns whose values are known at COMPILE TIME (given by user). Dynamic Partition (DP) columns: columns whose values are only known at EXECUTION TIME. Syntax DP columns are specified the same way as it is for SP columns – in the partition clause. The only difference is that DP columns do not have val