You need to redo all your joins into ANSI 96 syntax. Remove joining
code from the WHERE clause and put it in the FROM

FROM
MY_TABLE_1 JOIN MY_TABLE_2
ON MY_TABLE_1.KEY_FIELD = MY_TABLE_2.KEY_FIELD
WHERE

Yes FB is much faster.

In addition, you need to qualify every field in the statement of multi
table selects. Make sure the TABLE_NAME is included as part of the field.

WHERE
ZIP_CODE = '12345'

may not use an index where

WHERE
ADDRESS.ZIP_CODE = '12345'

will.


RB Smissaert wrote:

> We will be moving from IB 5.6 to FB and I had heard that FB should be
> faster, but sofar I haven't seen this yet. I understand a major weakness of
> IB 5.6 is the poor plan generator and I wonder if this is any better in FB.
> Are there any comparisons between these 2 available somewhere or any
> comments otherwise?
>
> RBS
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>
>
>