删除许多记录后如何优化表 [英] How do I optimize table after delete many records

问题描述

我从表中删除了许多记录，但是数据库大小(Firebird)保持不变.我该如何减少呢?

I deleted many records from my table but the DB size (Firebird) left the same. How do I decrease it?

我正在寻找类似于PostgreS中真空的东西.

I am looking for something similar to vacuum in PostgreS.

推荐答案

这是Firebird遇到的许多麻烦之一.最好，唯一有效且正确的方法-使用 gbak 备份/还原数据库

This is one of many pains of firebird. Best and only effective and right way to do this - backup/restore your database using gbak

这篇关于删除许多记录后如何优化表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！