>
> 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]