A rather straightforward issue here, prompted by a question on the forum at DBA Support.
When you place a predicate on a function of a partition key column then the optimizer is prevented from pruning unless there is a check constraint to indictate logical equivalence between the column and the function of the column. Continue reading