On 3 May 2019, at 9:34pm, Jen Pollock <[email protected]> wrote: > SELECT filename > FROM images > JOIN embedded_files ON images.file_id == embedded_files.id > WHERE type == 'png';
Try this: CREATE INDEX images (type, file_id); ANALYZE; _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
