Hello, In "index using and explain using question", Dennis Cote wrote: "An EXPLAIN QUERY PLAN returns three columns. The output of explain query plan is not documented (to the best of my knowledge anyway), but is fairly self explanatory. It shows the order that tables are scanned and which indexes, if any, are used to speed up the scans." http://www.mail-archive.com/sqlite-users@sqlite.org/msg24924.html
That said, what's the meaning of the first two numeral columns in explain query plan? E.g.: 0|2|TABLE document WITH INDEX document_name ORDER BY 1|1|TABLE document_token WITH INDEX document_token_document_id 2|0|TABLE token USING PRIMARY KEY Or: 0|0|TABLE token WITH INDEX token_name 0|0|TABLE token WITH INDEX token_name 0|0|TABLE AS token 1|1|TABLE document_token WITH INDEX document_token_token_id 2|2|TABLE document USING PRIMARY KEY Thanks in advance. Kind regards, -- PA. http://alt.textdrive.com/nanoki/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
