Thank you Martijn,
As usual, prompt, wonderful support from this group!
Regardsd,
Norman

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, March 09, 2009 1:52 PM
Subject: Re: [firebird-support] Firebird optimize table


> 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
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>


--------------------------------------------------------------------------------



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.8/1986 - Release Date: 03/05/09
19:32:00