| List: | General Discussion | « Previous MessageNext Message » | |
| From: | mos | Date: | March 12 2009 3:41pm |
| Subject: | Are equi-joins faster than left joins? | ||
| View as plain text | |||
I have 3 tables that are 1:1 and will always have a row for a given product,_code & date. If I want to join them together, is it going to be faster to use an equi join or a left join, or does it matter? TIA Mike
| Thread | ||
|---|---|---|
| • Are equi-joins faster than left joins? | mos | 3 Apr |
| • Re: Are equi-joins faster than left joins? | Arthur Fuller | 4 Apr |
| • Re: Are equi-joins faster than left joins? | Rob Wultsch | 5 Apr |
| • Re: Are equi-joins faster than left joins? | Martijn Tonies | 5 Apr |