Subject Re: [firebird-support] query optimization feedback/tools?
Author Daniel Rail

At September 9, 2004, 18:45, Emile Snyder wrote:

> I've looked in the IB6 Language Reference and Operations Guide and can't
> seem to find what I'm after.

> As a user migrating from mysql, I'm used to being able to do 'explain
> select ...<query guts>...' and see some information about which parts of
> the query are using indices, how many rows in the result table they're
> responsible for, etc.. I found a few mentions of using PLAN in firebird
> select queries, but no examples.

> Can anyone point me to some info on "the firebird way" to do this sort
> of thing?

The easiest way is to get your hands on a GUI tool that will give you
the query plan.

You can find a list here:
Some tools are free and some are not.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (