| Subject | Re: [firebird-support] Join to same table twice - or joins vs subqueries |
|---|---|
| Author | Ann Harrison |
| Post date | 2015-08-21T14:00:06Z |
> On Aug 21, 2015, at 12:10 AM, dmiller@... [firebird-support] <firebird-support@yahoogroups.com> wrote:Subselects are harder to optimize than joins. In a straightforward query like yours it doesn't make any difference, but in some cases a query with subqueries will be slower than one that uses inner joins.
>
> If subselects don't offer a performance advantage, and since I find them
> far more confusing than join syntax - I guess I'll forget about them
> until I have a problem they're designed to solve.
Good luck,
Ann