15 Aug Surfaces perhaps not as part of the record is ignored
Partitioned Dining table Assistance
Delete helps explicit partition alternatives with the PARTITION term, that takes a summary of the fresh comma-parece of just one or higher surfaces or subpartitions (or one another) where to choose rows becoming fell. Offered an effective partitioned dining table t that have a beneficial partition titled p0 , executing the brand new statement Remove Out of t PARTITION (p0) has got aplikace daf the same effect on the brand new dining table as the doing Changes Dining table t TRUNCATE PARTITION (p0) ; in both cases, the rows within the partition p0 try fell.
PARTITION can be used along with a WHERE condition, in which case the condition is tested only on rows in the listed partitions. For example, DELETE FROM t PARTITION (p0) WHERE c < 5 deletes rows only from partition p0 for which the condition c < 5 is true; rows in any other partitions are not checked and thus not affected by the DELETE .
New PARTITION condition can also be used in the numerous-desk Remove statements.