Subject Re: [firebird-support] VIEW optimization
Author Gabor Boros
2016. 04. 07. 21:41 keltezéssel, Ann Harrison aharrison@...
[firebird-support] írta:
> You're thinking of a case where there is a (possibly unstated) referential
> relationship between the table that you're getting fields from and the other
> table in the view. The table you're getting data from is the referencing
> table and the other is the referenced table. In that particular case, the
> join doesn't matter, but there's no way that Firebird can know that.

Hi Ann,

Thank you for the detailed answer! So, I am smarter than Firebird,
because I know which JOIN needed and which not. :-)