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

[Yuri]

On 01/20/2016 09:21, Hick Gunter wrote:
> ave you tried running ANALYZE on a representative dataset? This will 
> determine the "shape" of your tables and allow the query planner to make 
> better guesses of the costs associated with each join.
>
> If, after ANALYZE, you still feel the need to improve over the query 
> planners' ordering, you can still use CROSS JOIN to force a certain order of 
> tables.
ANALYZE helped, thanks!

Yuri