[sqlite] SQLite scans the largest table in the query where a very small table is available

[Matthias-Christian Ott]

On 2016-01-20 18:14, Yuri wrote:
> Does SQLite optimizer look at the row counts? (I think it does because
> the plans are different when there are no rows present).
> How to correct the problem?

If you want to do a manual optimization, the following describes how to
set the order of joins manually:

https://sqlite.org/optoverview.html#table_order