Delete any row for which a partitioning expression evaluates to a value outside the valid range of 1 through the number of partitions defined for that level.
This option is valid only for row-partitioned tables. You cannot specify the WITH clause for join indexes.