Re: [sqlite] Question about explain plain

cricketfan wrote: > I have a composite index on queuedb made up of q_id, date,priority(in the > same order). I am trying to find out if the index is being used for both the > where clause and the order by clause. Yes it is. > dbsql> explain select * from queuedb where q_id='598535' order by q_id

Re: [sqlite] Question about explain plain

On Fri, Dec 17, 2010 at 9:44 PM, cricketfan wrote: > dbsql> explain query plan select * from queuedb where q_id='598535' order > by q_id, date,priority LIMIT 1; > orde from deta > - > 0 0 TABLE queuedb WITH INDEX q_index ORDER BY > > Why is it

[sqlite] Question about explain plain

I have a composite index on queuedb made up of q_id, date,priority(in the same order). I am trying to find out if the index is being used for both the where clause and the order by clause. I have also posted the output for EXPLAIN QUERY PLAN. dbsql> explain select * from queuedb where q_id='59853