I am creating an interval partitioning on a table to improve SELECT queries on the table. I would like to understand does partitioning impact performance of DMLs:
a. when the partition key is present in the where clause of DML. (improve/ degrade/ no impact on performance)
b. when the partition key is absent in the where clause of DML(improve/ degrade/ no impact on performance)