I’d like to quetions about bulk delete.
When performing bulk deletions,
Oracle performs drop by partitioning the table as a date. Quick bulk delete is possible because no logs are left.
The table specifies the date as ‘Columstore Index Key’.
When I perform a deletion by setting a range of dates in the Where clause,
Is it fast because it is deleted as a unit by ‘sorted-Row-Segment-Group’?
We need to explain how fast it is by the mechanism.