I am trying to optimize a query by using the EXPLAIN QUERY, but the documentation on the web (http://www.sqlite.org/eqp.html) does not match the version of SQLite I am using (v3.6.23.1). The documentation says there are three columns, but I am only seeing two columns. What do the two columns mean?
Here is my results: sqlite> EXPLAIN QUERY PLAN ...> SELECT DISTINCT ...> f1.FolderId, ...> f1.ImageId, ...> (SELECT MIN(f2.instertedon) FROM Favorite f2 WHERE f2.FolderId = f1.FolderId AND f2.ImageId = f1.ImageId) timeMarker ...> FROM Customer c ...> JOIN Favorite f1 ON c.CustomerId = f1.CustomerId ...> WHERE c.IsInSlideShow = 1 ...> AND f1.Selected = 1 ...> AND timeMarker > julianday(0.0) ...> ORDER BY timeMarker; 0|0|TABLE Customer AS c WITH INDEX Customer_IsInSlideShow_index 1|1|TABLE Favorite AS f1 WITH INDEX Favorite_Selected_index 0|0|TABLE Favorite AS f2 WITH INDEX Favorite_FolderId_ImageId_instertedon_index ORDER BY 0|0|TABLE Favorite AS f2 WITH INDEX Favorite_FolderId_ImageId_instertedon_index ORDER BY 0|0|TABLE Favorite AS f2 WITH INDEX Favorite_FolderId_ImageId_instertedon_index ORDER BY 0|0|TABLE Favorite AS f2 WITH INDEX Favorite_FolderId_ImageId_instertedon_index ORDER BY _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
