Subject Re: [firebird-support] Firebird optimize table
Author Martijn Tonies
Hello 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?

No and no.

> I've browsed the FAQ's, release notes and even the Intebase Docs, but find
> no references.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: