Sorry, it seems gmail messed up the layout just before sending.
On Sun, Apr 28, 2013 at 4:02 PM, Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> wrote: > I was playing with indexes, I started checking one my queries with > EXPLAIN QUERY PLAN and > I got this result: > selectid order from detail > ---------- ---------- ---------- > --------------------------------------------------------------------- > 0 0 1 SEARCH TABLE tour AS t2 USING > INTEGER PRIMARY KEY (rowid=?) (~1 rows) > 0 1 0 SCAN TABLE tour AS t1 (~5000 rows) > > Adding an index on the column unsorted_path it becomes: > selectid order from detail > ---------- ---------- ---------- > --------------------------------------------------------------------- > 0 0 1 SEARCH TABLE tour AS t2 USING > INTEGER PRIMARY KEY (rowid=?) (~1 rows) > 0 1 0 SEARCH TABLE tour AS t1 USING > INDEX t (unsorted_path=?) (~2 rows) > > And it seems quite an improvement, alas now I get this error: "cannot > open indexed column for writing." > > What does it mean? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users