I've blogged about common_schema multiple times in the past, and it's a tool I use frequently.
Last week I had a project to delete millions of rows from
multiple rollup tables in a star schema. Since the tables are not
partitioned I needed to use
DELETE instead of
DROP PARTITION, but I didn't want to delete millions
of rows in a single transaction. My first instinct was to use