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