| Subject | Re: [firebird-support] VIEW optimization | 
|---|---|
| Author | Gabor Boros | 
| Post date | 2016-04-08T07:53:34Z | 
2016. 04. 07. 21:41 keltezéssel, Ann Harrison aharrison@... 
[firebird-support] írta:
Thank you for the detailed answer! So, I am smarter than Firebird,
because I know which JOIN needed and which not. :-)
Gabor
            [firebird-support] írta:
> You're thinking of a case where there is a (possibly unstated) referentialHi Ann,
> 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.
Thank you for the detailed answer! So, I am smarter than Firebird,
because I know which JOIN needed and which not. :-)
Gabor