On 30 Oct 2013, at 3:00am, RSmith <rsm...@rsweb.co.za> wrote: > Secondly, A query that seemingly requires no sorting sometimes give quite a > large figure for the Sort-Ops, what is it about this that I am not > understanding?
You may find that adding the information given by EXPLAIN QUERY PLAN SELECT ... to the information you've already gathered helps you understand how SQLite executes your query. It certainly helps you investigate some of the raw numbers you're referring to. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users