I did an ANALYZE but I'm getting the same results. I do have indexes: CREATE TABLE movies ( movies UNIQUE, name, icon_modified );
CREATE TABLE genres ( genres, movies, UNIQUE(genres,movies) ); people has an index on people (people UNIQUE) and tasks is a view: CREATE VIEW tasks AS SELECT 'creators' tasks,movies,people,'' details FROM creators UNION ALL SELECT 'directors' tasks,movies,people,'' details FROM directors UNION ALL SELECT 'writers' tasks,movies,people,'' details FROM writers UNION ALL SELECT 'actors' tasks,movies,people,characters details FROM actors; The tables creators, directors, etc, have similar indexes as genres: CREATE TABLE directors ( directors, people, UNIQUE(directors,people) ); -- View this message in context: http://sqlite.1065341.n5.nabble.com/Please-help-me-optimize-this-LEFT-JOIN-query-tp71000p71033.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
