Thanks for the PLANalyzer pointer. I can't seem to download it from the
borland site that this feeds through to though; their web server gives
me "catastrophic error" messages ;) Anywhere else to get it?

thanks,
-emile

On Fri, 2004-09-10 at 05:36, Carlos Macao wrote:
> 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
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>

+----------------------------------------------------------------------
"Usenet is like a herd of performing elephants with diarrhea -- massive,
dif- ficult to redirect, awe-inspiring, entertaining, and a source of
mindboggling amounts of excrement when you least expect it." -- Gene
Spafford (1992)
+----------------------------------------------------------------------