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

[Richard Hipp]

On 1/20/16, Yuri <yuri at rawbw.com> wrote:
>
> Does SQLite optimizer look at the row counts?

It does if they are available.  Run ANALYZE to generate the row counts.

-- 
D. Richard Hipp
drh at sqlite.org