But of course. I should have included them :)
Thank you
Hans

All joins on PK's (not NULL) .
Index selectivities about the same, if present.

FB1.5 .. without the two left outer joins

PLAN SORT (SORT (JOIN (M NATURAL,T INDEX
(TICKETS_REF_TICKET_NO,TICKETS_MUD_UNIQUENUM),S INDEX
(RDB$PRIMARY12,RDB$PRIMARY12),W INDEX (RDB$PRIMARY21),O INDEX
(RDB$PRIMARY5))))

with the two left outer joins

PLAN SORT (SORT (JOIN (JOIN (JOIN (JOIN (T INDEX (TICKETS_REF_TICKET_NO),S
INDEX (RDB$PRIMARY12,RDB$PRIMARY12)),O INDEX (RDB$PRIMARY5)),W INDEX
(RDB$PRIMARY21)),M INDEX (RDB$PRIMARY5))))

FB2.0 .. without the two left outer joins

PLAN SORT (SORT (JOIN (JOIN (W NATURAL, S INDEX (SITES_HOUSE_LSD_CUST), O
INDEX (RDB$PRIMARY5)), JOIN (T INDEX (TICKETS_REF_TICKET_NO), M INDEX
(RDB$PRIMARY5)))))

with the two left outer joins

PLAN SORT (SORT (JOIN (JOIN (JOIN (JOIN (S NATURAL, T INDEX
(TICKETS_REF_TICKET_NO)), O INDEX (RDB$PRIMARY5)), W INDEX (RDB$PRIMARY21)),
M INDEX (RDB$PRIMARY5))))

----- Original Message -----
From: "Arno Brinkman" <fbsupport@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, December 04, 2006 2:51 PM
Subject: Re: [firebird-support] More FB 2.0 / FB1.5 optimizer differences


> Hi,
>
>> What I'm I doing wong ?
>> Any ideas ?
>>
>> Tried doubling buffer sizes in FB2.0 .. but
>
>> ------------------------------------------------------------------------
>> Same Server, Same data
>>
>> FB1.5: runtime 29 Secs ODS 10.1
>> FB2.0: runtime 240 Secs ODS 11.0
>> ------------------------------------------------------------------------
>
> Could you post the PLANs return by FB1.5 and FB2.0 for both queries?
>
> Regards,
> Arno Brinkman
> ABVisie
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> General database development support:
> http://www.databasedevelopmentforum.com
>
> Firebird open source database (based on IB-OE) with many SQL-99 features :
> http://www.firebirdsql.org
> http://www.firebirdsql.info
> http://www.fingerbird.de/
> http://www.comunidade-firebird.org/
>
> Support list for Firebird and Interbase users :
> firebird-support@yahoogroups.com
>
> Nederlandse firebird nieuwsgroep :
> news://newsgroups.firebirdsql.info
>
> --------------------------------------------------------------------------------
> Mijn Postvak In wordt beschermd door SPAMfighter
> 1051 spam-mails zijn er tot op heden geblokkeerd.
> Download de gratis SPAMfighter vandaag nog!
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>