Subject Re: [ib-support] Re: Same Query - Dirrerent GDBs - Different Plan
Author Ann W. Harrison
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.


We have answers.