Am 18.12.2009 um 15:58 schrieb Pavel Ivanov:
> As you said because of your LEFT JOIN SQLite (or any other DBMS in its
> place) is forced to use t2 as a base table. You have no conditions on
> t2, so SQLite will make full scan on it and for each row it will need
> to pick up a corresponding rows
As you said because of your LEFT JOIN SQLite (or any other DBMS in its
place) is forced to use t2 as a base table. You have no conditions on
t2, so SQLite will make full scan on it and for each row it will need
to pick up a corresponding rows from t1 which it does using primary
index.
And FYI, by
2 matches
Mail list logo