Hi Emile,

<<< 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. >>>

Look at http://delphi.buzzword.com/IBPLANalyzer

Best regards,
Carlos Macao