删除优先级

200G表数据删除;
删除优先级:
分区/id/其他字段;

尽量按照分区删除而不是id;

alter table url_day drop partition p201804;
alter table url_day drop partition p201805;
alter table url_day drop partition p201806;
alter table url_day drop partition p201807;

分区删除

原文地址:https://www.cnblogs.com/rsapaper/p/10368287.html