> > Actually, it doesn't. The order of joins is determined by the optimizer in > the case of an inner join, but outer joins determine the order > semantically. Consider this case: >
so, if FB optimizes INNER JOIN why didn't it use a more selective index on commit_number instead of less selective index on source_id? Especially given that there was an ORDER BY on commit_number? > select c.city, s.stateName > from cities c > inner join states s on c.stateCode = s.stateCode > where c.population > 1000000 > > I am assuming you meant to use LEFT not INNER JOIN, right? Thanks, Alec [Non-text portions of this message have been removed]