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