| Subject | Re: [firebird-support] LEFT JOIN much faster than JOIN |
|---|---|
| Author | Josef Kokeš |
| Post date | 2013-08-02T12:04:18Z |
On 2.8.2013 13:59, Alexis Diel wrote:
can (potentionally) filter out some records.
Josef
>Which should make JOIN faster than LEFT JOIN, if anything, because it
>
> but LEFT JOIN is diferente of JOIN...
> - LEFT JOIN brings all the data filtered from the FROM table, and
> - JOIN brings only the data that have the ON condition in the JOINED table.
can (potentionally) filter out some records.
Josef