Chris Eich <[EMAIL PROTECTED]> wrote:
Overview Of The Optimizer <http://sqlite.org/optoverview.html> (1.0
says "column = expression" not "constant expression", 5.0 says "joins
are nested loops") and the EXPLAIN QUERY PLAN output gave me this
mental model:
for (d in device)
for (dpi in index(dpi1, 1, d.device_id, 300))
...
It's pretty clear that the actual execution plan chosen by SQLite is
along the lines of
for (dpi in index(dpi2, 1, any, any, any))
for (d in device(device_id = dpi.device_id))
...
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
