A、You cannot create global range partitioned indexes on the table. 

B、The optimizer will not execute partition wise joins on the table’s partitions. 

C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. 

D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.