On Fri, Dec 17, 2010 at 9:44 PM, cricketfan <srtedul...@yahoo.co.in> 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 not indicating that the ORDER BY is using the index? Or is it > really using it? > The EXPLAIN QUERY PLAN output was revised and enhanced for version 3.7.4. The new EXPLAIN QUERY PLAN output provides much more information and (for the first time) is documented. See http://www.sqlite.org/eqp.html for details. The output above is from a pre-3.7.4 version of SQLite. The ORDER BY at the end indicates that q_index is being used to order the output so that no sort is required. > -- > View this message in context: > http://old.nabble.com/Question-about-explain-plain-tp30486201p30486201.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
