GBase 8a数据库RANGE分区操作详细解读
- 删除过期分区(秒级释放空间!-- 查看分区信息SELECT PARTITION_NAME AS 分区名,PARTITION_DESCRIPTION AS 分区边界值,TABLE_ROWS AS 预估行数FROM information_schema.partitionsWHERE TABLE_SCHEMA = '你的库名' -- 替换成你实际的数据库名AND TABLE_NAME = 'txn_flow'ORDER BY PARTITION_ORDINAL_POSITION;







