Woooh

You had me scared there for a moment Adam !

I have never used IBPlanalyzer before but as the plans seem identical It
seems that it might not be very useful. This is way beyond me too :)

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Adam wrote:

>Hi Rob,
>
>Didn't you hear they added a new feature that makes it slower to
>compare strings to 'T' than 'F'.
>
>No, just kidding.
>
>Starting to get beyond my experience here, but have you had a look at
>something like IBPlanalyzer to see how many records are being hit from
>each table? Is there an index available for the join to take place
>efficiently? How many records are in each of the tables?
>
>Obviously doing comparisons on non-indexed fields is going to be a
>recordset scan of some form, so you need to know how many records are
>being hit to decide to return 208 of them.
>
>Adam
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>
>