At 05:02 PM 10/2/2002 +0200, Svein Erling Tysvaer wrote:

> >but no matter how 'wrong' the SQL is - you'd still expect the
> >same plan ?
>
> The only reason I can think of why it
>would choose the second plan was if WAYBILL contained a lot less records
>than ROUTING ... I hate it when FB/IB does this kind of things ...
>
>Maybe Ann or someone could give you useful advice if you provided some more
>statistics about each database?

The information that would help is the selectivity numbers from
rdb$indices for the tables involved.

Regards,

Ann
www.ibphoenix.com
We have answers.