| Subject | Re: [ib-support] Re: Query optimiser - inner join - left join |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2003-03-06T09:20:28Z |
Sorry Andrew,
unless there is a foreign key on PURCHREQTAGS.INC_REQN that you've hidden
from us, I have no idea why Firebird chooses such a silly plan (from what
you've told us, it certainly seems like a stupid plan).
Hope this gets others to investigate your problem and find an explaination,
Set
unless there is a foreign key on PURCHREQTAGS.INC_REQN that you've hidden
from us, I have no idea why Firebird chooses such a silly plan (from what
you've told us, it certainly seems like a stupid plan).
Hope this gets others to investigate your problem and find an explaination,
Set