Chris Eich <[EMAIL PROTECTED]> wrote:
But the basic question I have is why (given d, dpi order) the
device_id
can't be plugged into the dpi1 index.
I believe it can. What makes you think it doesn't?
EXPLAIN QUERY PLAN output
doesn't show
how much of the index will be used--does anyone have a quick hack to
show
that (I'm studying where.c :-)?
Try just EXPLAIN instead of EXPLAIN QUERY PLAN. This outputs the query
plan in the form of a program for certain abstact machine - see
http://sqlite.org/vdbe.html
http://sqlite.org/opcode.html
It takes some patience to interpret this, but every little detail is
there.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
