Subject | Firebird optimize table |
---|---|
Author | Norman McFarlane |
Post date | 2009-03-09T11:47:46Z |
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.
Regards,
Norman
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.
Regards,
Norman