Subject Firebird optimize table
Author Norman McFarlane
Hi everybody,
In my on-going project of converting a MySQL DB to Firebird, I have come
across a SQL statement which reads as follows:
OPTIMIZE TABLE <tablen ame>
It is supposed to be useful for compacting tables which have a variable row
width, which become extremely slow weith repeated deletes and inserts.
Is there an equivalent in Firebird, and is it even necessary?
I've browsed the FAQ's, release notes and even the Intebase Docs, but find
no references.