Subject query optimization feedback/tools?
Author Emile Snyder
Hi all,

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?


"This `telephone' has too many shortcomings to be seriously considered
as a means of communication. The device is inherently of no value to
us." -- Western Union internal memo, 1876.